Skeptical this will ever happen. Climate collapse is speeding up, and therefore a full collapse of humanity (in the nearby future, say 100-200 years) is becoming more realistic. So colonization of other planets or the moon is a race against time, which humanity probably won’t win. I don’t want to sound too pessimistic; this is a realistic view, supported by many international scientific organizations.