There is no such thing as schedule 40 HDPE for water use, it’s all SDR design. I wouldn’t worry about the pipes collapsing, they only have to account for the head difference from the lake surface to the highest elevation of the embankment, lets say 15 feet or approximately -7 psi. A thick walled HDPE pipe can handle…