Moved from Sim Update 3 Beta | MSFS 2024.
This has been the case since MSFS 2024 was released (e.g. the comment by @CharlieFox00 " I did exit and found I could walk on water…" here).
The sim does not model water depth (oceans, seas, lakes or rivers), so the avatar is only standing in around an inch of water.