I’d like it if significant numbers of humans were able to live off Earth, whether in orbital habitats or on other planets and moons. It seems to me that the increased productivity and labor supply of robots should make this more feasible in the future. People (not all, but many) need something to do and somewhere to go.
Our best chance for a spare civilization in the event Earth gets wiped out is to build underground on Mars. Not enough protection from the atmosphere from radiation and meteorites, but apparently there is enough water trapped below make a go of it.