I would think you could scoop out a log for this.
Don't know how deep a catfish would prefer a cavity tho. Someone else could chime in here.
If your earthenware is fired in a kiln, it should not decay very easy, although, it may be brittle.
Maybe just get some plastic culvert or drainage tile material and go that rout. Seems less labor intensive that way.