I had a moment in my 20s where I just stopped and thought, "Every single ancestor I had from my parents back to algae had offspring. What if I don't?"
If you consider the whole Ocean as history, and the present moment as a single solitary wave heading towards the shore, and your life as the surfer on that wave, it doesn't matter what came before you. What matters is the wave. You get to ride it and wipe out. And that's it. I don't care if that wave is a composite of a million unknown ripples in the cast Ocean. It doesn't matter really.
A large proportion of your ancestors offspring didn't themselves have offspring.
The answer to that isn't having material wealth, especially when you get no time left over to appreciate it. So the problem is having enough time when you waste most of it toiling for the dreams of another man, and for next to nothing in return. Because that's the real economy. (If you do, though, then congratulations I guess, but then you're not in the position of most people anyway.)
I think, however, that you'd change your mind about things if you had the freedom, the space, and the ability to grow your own food. Then you'd see how foolish most city dwellers actually are. As for the philosophical musings about whether you should have children... Well, it's your life, man. If you don't want a shot at prolonging your true legacy, then that's up to you. But you're certainly doing a service for everyone else who do want their kind to succeed.
In terms of your moment in your 20s, the way I see it is that it goes beyond my conventional existence as a human: I'm not just the product of all my direct ancestors, but also of all the causes and effects which have effected those ancestors. It's obvious that I am the continuation of my great great great grandfather, however I am also the continuation of my great great great grandfathers lunch that fed him, or doctor that saved him, or the Sun that supported him. Reproduction is an essential component for continued existence of sentient beings, but so is food, so is warmth, so is water. I feel that the Sun is just as much my parent as my biological parents.
It is wonderful.
Tiring, taxing, exhilarating, inspiring.
It works for me. I make no claims for others.