A desirable location will never have enough capacity. Regardless of how much building occurs. If you don’t believe me, look at NYC, Paris, etc, etc.
People move as close to a desirable location as they can afford. And often more.
Don’t get me wrong, rules set where and how bad the line is, but there is no realistic situation where everyone who wants to live in SF can, and can afford to, and it is anything like SF.