No matter where a person lives, no matter how beautiful it is, I think that we all get sick of seeing our surroundings and wouldn't mind a change of scenery. Venice is one of the most beautiful cities in the world, but I wouldn't want to live there for exactly the reasons in the OP, I'd get sick of the water, but if you are born and brought up there then it would just become a part of life.
Turning it around, if a person left Venice then they would probably end up missing the water and that way of life in the same way that we would probably miss our roads and fast food restaurants on every corner, and that's something else they don't tend to have as many of.