Part of the reason San Francisco is so desirable is because it's iconic, it would be a great irony to make room for more people by removing what makes it special.
It always felt to me like if we want more San Francisco then we should build more beautiful cities, there's a lot of amazing coast in California.