I would not be comfortable knowing, that the children I helped bring into this life are doomed in the long run. That would be pointless to me, there needs to be a way forward, whether it is mars or something else.
I don't get it.
Basically: Let's face it, when we're dead then we're dead. That's it. You have your life. Trying to achieve some sort of immortality or higher purpose by creating offspring is just as futile as praying or paying some quack to help you with afterlife matters.
If you feel that unconnected, than yes, that was it to you.
And sure, I will be dead one day, too and my name forgotten. That doesn't mean, my life was without purpose nor significance, because I do feel part of something bigger. Progress of humankind and the spreading of life and consciousness in general.
I don't know the names of my ancestors, but they are of significance, as without them, I wouldn't exist and without me, neither would the 1000. generation after me.