The absolute delusion Musk followers have is unbelievable. They entirely ignore what a thousand experts say and instead go along with their cult leaders vision. You’ll get a base on the moon easily enough and it will be nothing more than an ISS type extension and there will probably be commercial mining for Helium 3; which will mostly be done by droids. You will Probably get tourism for the wealthy much like you have for Mt Everest for the wealthy who pretend they can climb.
As for Mars a few countries will land there, and some may even have a base for 3-5 people for a decade or so to survey it with a rotation but no real settlement. The planet is wholly worthless.
Any mining on asteroids is to be done by mostly droids. You will get a small rotation crew of a few people. This could potentially grow to be genuine enterprise in a century.
You’ll get an LEO hotel and science stations for certain; mostly for military and pharma research and this is what Elon and Bezos are literally banking on in addition to Moon base hardware for
Mining/military/tourism.
Essentially we are never leaving Earth’s Orbit by and large and ideas of space colonization is pure science fiction even with breakthroughs in energy production and propulsion. Elon isn’t delusional; he just knows what to say to a populace to get them excited and behind him from a public PR exercise.
Working on the LEO stations will not be fun. The hotels mildly so. Working on the moon bases will be even less so. Working on any asteroid mining will be even More depressing than an actual earth mine.
Being stuck on Mars for 2 years will be an honor, a privilege and utterly depressing. The stupid goal of mars won’t bankrupt Elon; it will bankrupt the stupid countries dumb enough to think planting a flag on it means something and waste a trillion dollars on a PR stunt - again, Bezos and Musk are banking on this stupidity. And if they are dumb enough to want a big base in there, why wouldn’t you take their money?
Finally it must be said that possibly fusion reactors may have to be built in space thanks to no atmosphere, convection issues and zero gravity and energy beam transmission to power earths appetite for energy or giant solar arrays - but this isn’t colonization and again, Musk and Elon are banking on this being possible too.
Space has tightly defined perimeters for what is commercially viable and breeding humans isn’t one of them.