You think ‘yeah stuff is weird now but it’ll all work out in the end’
That’s not what’s happening here, we are well past the cusp of catastrophic social collapse, WELL past
I'm kinda glad that somebody else sees it that way too. I've been thinking it for a while now. I (for reasons i can't explain) believe that women can feel the future (somehow) and intuitively don't want to have children anymore. If i look around and ask anybody i know, very few people my age (20 - 30) say that they intend to ever have children.
Now, i agree with you that automation, and more importantly the end of growth will make workers largely superfluous. I suspect that instead of some kind of retirement or subsidy-based living, the rich actively try to kinda "terraform" the whole population by getting rid of the workers and only keeping everybody else, and i suspect that we're gonna see a population decline as steep as we saw an ascent during the last centuries:

Just in reverse, i.e. in 2200, we might have 1 billion people on earth again.
The reason will largely be unemployment (or rather underemployment - not earning enough to make a living) instead of a resource shortage (such as agricultural shortages).