That's true in Amsterdam, and it's true in San Francisco. And it's true in Berlin where I currently live. Plenty of space to build cheap apartments on but it's controversial in all three to do so. So, this is a nice solution/workaround for this artificial scarcity. I imagine the Bay would be suitable for living on. But of course most of it is protected nature. That's a much more valid concern than the notion that there's not enough water.
I actually looked into what it would take to put a housing boat in the Spree (river that runs through Berlin). People actually do that and you can get some decent value for money! Obviously it won't scale before local authorities put a stop to that (to preserve the local artificially scarcity and locked up wealth). But it's an interesting loophole if you are a bit entrepreneurial. No expensive land needed to build on. Easy access to reasonably fashionable parts of town. Etc. All you need is a boat and permission to dock it somewhere. As long as that permission is still easy to get, it's a valid thing to pursue.
https://ourworldindata.org/land-use
It seems that human development and freshwater are the same.
No there are not plenty. Sure 70% of the earth is covered in water, but only 2.5% is freshwater, and a fair amount of that is lakes large enough to have currents and large waves as well (I don't know how to figure out how much is stable enough that you could consider living on a boat there. I think we can estimate that 2% of the earth is the type of place where you could consider living in a boat - and much of that isn't a place where you want to live (ie not a city), and the rest needs to a lot of land reserved for shipping lanes.
Living in a boat is an interesting niche that a few people can do. However it isn't a solution for any housing problem.