All these dreams of star-trek like interstellar travel (or even interplanetary travel beyond taking a selfie and going home) require major advances in the physics tech tree. Might come, might not.
We have plenty of earthbound motivation to solve the "energy too cheap to meter" problem. We're nowhere near that. Adding one more big energy consumer (moving cargo to/from orbit) does not make a material difference.
Starship is supposed (Musk hype warning!) to be 1/10th to 1/100th the cost.
We haven't done skyhooks or launch loops or launch cannons, which are large upfront projects but once built are semi-permanent economic gamechangers.
I always felt like that was a backwards justification for going to space (we want to go to space, how do we sell it), rather than a real need to that would push people to go to space.
Though the rather limited space on the ISS and its imminent decommissioning complicate that a bit. I think the current plan is to launch satellites for commercial production
A moon colonization program provides both.
"Moon base that produces positive economic benefit" is about 10 steps up a very expensive tech tree and we don't even know what the rungs are.
I also don't think this is very imaginative. If you want to colonize the moon, why send a man in a can? How about genetically engineering a human-ish that's better adapted to that kind of environment? That's the kind of technology advancement that makes manned interplanetary missions reachable.
The exact opposite of that has been the meta in most 4X games I've played.
You always rush specific techs because you understand the ROI for the specific empire you're going for. That involves specialization.
Apollo allowed America to demonstrate its ability to land a rocket with pinpoint accuracy on the Moon, implying it would be easier to land an ICBM on the Soviets.
The USSR got a large PR boost through launching Sputnik and then a person. It convinced many people communism was a superior ideology for advancing science and technology. Turning it into a "Space Race" allowed the USA to reframe the discussion for the world in a way that let America catch up.
Given current American politics, I'm honestly divided on whether we should colonise the Moon. That someone will do it seems pretty obvious.
One interesting (admittedly small in scope, but huge in impact) thought experiment is the following- let's say that the doomsayers are correct. The Earth has been destroyed and inhabitable, leaving just our extra-planetary outposts. How do we supply the necessary high-tech manufacturing capability to survive?
Have we spun up all of the supply chain to reproduce the state-of-the-art technology required just required to sustain life on that celestial body? As an example, even with all our experience on Earth, we have exactly one physical location on our entire planet that can crank out the most advanced chips used in our modern technology we take for granted. That build-out took massive investment of deca-billions of dollars plus a massive, deep supply chain to build, even with all the advantages we have here on Earth (things like, oh, breathable air, access to vast carbon energy storage, access to millions of humans and existing factories... just as a start...)
Are we expected to replicate all of that on our next celestial body? If not, how do we expect to replace failing parts and continue progress?
What about even more basic concerns about things like... literal population growth? We understand ... a little... about how very healthy adult human bodies react to prolonged periods in zero-g (hint: not well, where "prolonged" == 437 contiguous days [0]). What about pregnant women? Babies? Spaceflight crews are required to exercise two hours every day to counteract muscle and bone atrophy [1]. How is that expected of say... an infant?
Don't get me wrong, I find spacefaring fascinating. I idolize the Apollo era. But we haven't even scratched the surface of how we can sustain any sort of population off this planet. We need to find ways to get along here, because ... this is all we've got, folks.
[0] https://en.wikipedia.org/wiki/Timeline_of_longest_spacefligh... [1] https://www.nasa.gov/blogs/spacestation/2025/07/16/muscle-an...
If we find some faster-than-light travel mechanism and a star group that includes a planet like our own, then perhaps there's a way out of here.
On the other hand, why not try to achieve something like ... getting along better here? We could find ways to create more clean energy here on Earth, clean up existing messes, better harness the 3/4 of the globe covered by water, etc.
Plus we have a lot of societal issues to try to address. How would living on another planet solve distinctly human problems like war, conflict, need to pollute the natural environment of a new planet, etc? Why not look at how we can improve our own self-governance? After all, if we do escape this rock, it's not like we're magically going to become more altruistic, compassionate, etc. We'll still suffer from the same problems we do here, just with even more stressors like "my body boils over if I dare step outside unprotected". Sounds super depressing to me.