One of the reasons I'd like to see Civilization grow to some off planet status is that it nearly ends the possibility of another total collapse. Space is such an unforgiving environment that technical know how must be maintained or you die.
I could be in big trouble there. Not even slightly a techie. My son was, but he died in November. Our entire family would croak.