The future
I disagree. Once humans start getting out there, there are many that will want to stay. One thing for sure, the future is hard to predict, but if we don’t destroy ourselves, then we’ll spread out away from the Earth. Humans are very adaptable. We have adapted to every environment we have set foot on. I don’t see why the Moon, Mars and beyond will be any difference.
Also, it will be a growing process. Each generation builds on the previous one.
We’ll get it right.