I've attached full fluid pipes to vanilla cauldrons on side/bottom and neither works. (haven't tried top because that defeats the purpose of dripstone lava farm)

MC 1.18.2 - Tiny Pipes 2.0.4 Beta

Pretty sure cauldrons do not use forge capabilities. I don't know of any mod's pipes that pull from cauldrons. I know that Mekanism, Pipez, and Immersive Engineering do not.
I'll look into the possibility though.

I did find one mod that changes cauldrons to tile entities which allow pipes, but it also states the pipes should be able to transfer 1000mB.

Perhaps you could approach it from that angle by adding something which copies the drip lava effect of the cauldron but isn't a cauldron and attaches to your pipes? Or maybe just add that capability directly to full size fluid pipes so you can use them instead of the cauldron for the drip lava? Just thoughts, maybe spark some ideas.

On that note, I found a mod library specifically for copying/adding cauldron behaviors.

If you use Tiled Cauldron, it should work. You will need speed upgrades though if it is only capable of doing 1000mB at a time.