Anti-growth people will point to neighborhoods like Glen Park, NoPa and Noe as "SF" while forgetting most of the surface area of the city is empty neighborhoods like Parkside, Mt Davidson Manor, etc.
And because larger cities tend to also be more attractive (Tokyo is still growing, for instance), you’ll never have enough density to be ‘enough’ - aka where it’s cheap enough for everyone to live where they want.
You will have more people though.
There were two years during the pandemic when people moved out- because jobs let them - but people moved back and it has more than made up for it since.
Every major city in the world has seen significant population increases as mechanized farm work and fertilizers have removed the need for many farm workers, and economy activity has concentrated.
It’s been a consistent trend for almost 100 years.