This is because the trap is built overlaying water which rips up the redstone. Womp womp.

Generally speaking, dungeons don't work in oceans.

As well, IIRC, there is a hard constraint that prevents dungeons from spawning over water, including oceans and rivers.