And it doesn't even need to be a rigid pipe. A flexible pipe made out of, say, waterproof fabric, could be cheaply made to extend miles while remaining open due to the pressure of the water pumped into it.

Things left underwater tend to collect things on it which would make this much less porous over time.