Water is not synchronised with the terrain properly. It has some kind of an offset.
Found a similar Reddit post by description, and their solution to turn on UseFixedZ and UseFixedWaterDepth in the material settings of the water didn’t help. Does anyone know how to fix it?