I feel that speculating about the technical aspects are hard enough, speculating about what will happen politically/socially is too difficult. I think easy access to space (i.e. a moon colony, not a mars colony) will be technically/economically beneficial to the people on earth in the very very long term, if we make it.
But if wealth is distributed like it is today it would probably only benefit the 1%.
Those
1% insane asylum dodgers, sporting suits with fat asses parked on Chesterfields in secure ivory towers, will work out a way to abuse the Moon and Mars too,
for fast, lazy, easy big dollars.
That's what happens when the apathetic 99%
have faith in their twisted intelligence,
and allow them to control the money ship
No thanks, I'm sticking to what still works on this nice rock called Earth
Fools that want to blow -other peoples money- and take risks in order to realise the obvious 'no go zone MEANS
no go zone' reality at the end,
can keep their wet dream, and all the fun and misery following it up