Pistons are a full block so it makes no sence that a water source should be able to occupy the same space as them.
Pistons can be Waterlogged
Piston heads can become waterlogged.
Water leaks out through coral block
Bubblewater can glitch through magma / soulsand block