Depends.

ME is safer than SE if flown by pro pilots, but statistically is more dangerous with inexperienced pilots (Vmc risk of ME outweighs off-airport landing risk of SE).

A turbine SE plane is far less likely to experience an engine failure, but if it does the stall speed (and therefore touchdown speed) will be higher than in a light piston plane so the odds of surviving the ditching are lower. A ditching in typical light piston ASEL should always be survivable if done right.

A professionally flown turbine ASEL is most likely safer than a private pilot flown piston AMEL, even over water.

And sometimes water is a better place to land than terrain, I'd prefer water over a low altitude engine failure in a congested urban area (to say nothing of mountains at night).