I know actually living in Venice is a challenge. It's a long walk to run any errand, and if you need something delivered it has to come by boat, on a schedule, and so you have to have your act together.
But, if you mess up? You have to eat out. In Italy. There are worse things in the world.
Really, all I need is wifi, which I hear Venice has, and for my 3 kids to be passable swimmers.
And it's a problem that is very hard to solve, because a city must, almost by definition, be open; and because curbing tourism- even if it were feasible- means saying no to a huge amount of cash.
The time I went a few years ago it was pretty dead. I'm not a big Venice fan. It's a pretty city that's worth seeing before it sinks away, but I enjoy other cities for repeat visits.
I mentioned in another comment a few weeks ago that if I wanted to visit Venice again I would stay in Rovinj, Croatia and take the local ferry over for the day. When I went to Venice we took the ferry over and stayed in Venice, and after seeing the Venice highlights really just wanted to go back to Crotia.
However, I have been to Venice 3 times in the last 10 years. People here arguing that Venice is "full of people" have not visited the city, but only the cities attractions. It is as simple as that. Even in the peak season when the city center is massively overcrowded by tourists, you (literally) only have to walk 10 minutes from Piazza San Marco to find yourself basically alone on lovely squares in the middle of the day. It is at the same time extremely beautiful and eerie, because you suddenly realize that the square is not only empty because there are no tourists there, but also because most of the apartment windows are blind, with nobody living behind them. Offside the tourist routes, Venice largely feels like a ghost town.
It is indeed sad, but if you stay in the city as a tourist long enough, you get why locals are leaving. The last time, we stayed there for 10 days in a small apartment, and starting with day 2, our hatred for the masses coming off the cruise ships like a biblical locust plague grew exponentially to a point where we completely avoided the city center between 10 in the morning and 9 in the evening.