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.