does it have to be just BC pipes, or can it be any valid fluid container above the pump?

It just does not notice BC Pipes because BC Pipes rely on the fact that the other tileEntity has to have a Fluid Capability to connect. Else they won't accept liquid.

Any other TileEntityContainer should be fully supported.

done