Rough googling produces 89.6% of people become parents and it stands to reason that some of that remaining 11% would have wanted them but died first or were sterile.
The numbers suggest the vast majority of people prioritize producing offspring for whatever reason. It’s likely 10,000 reasons not one. Social pressure, for the grandparents, because everyone else is, because I want to pas son my genes, because she/he was too hot to worry about protection that night, etc.
The largest single issue with your comment though is that most of us probably don’t see the future as a grim resource constrained fact. Life over here in the West in 2020 is pretty good, historically speaking and in absolute terms. Even for the worst amongst us. We can backslide quite a bit and still be looking positivity towards our descendants expected quality of life. As for the developing world, in most of those places the quality of life has been a rocket ship during their lifespans so it would be rough for them to come that conclusion as well I would imagine.
I understand climate change is scary and recognize it could be the end but when faced with existential dread like that some people lay down and curl up while most people stand up and push forward harder. There are 1,000 ways we all die but billions of possibilities so I personally choose to live in today and face just the 1 death that comes for us when it comes rather than all 1,000 possibilities every time some hack journalist wants to clickbait up their revenue that quarter.