An insulting thing I read the other day was an understatement to the achievements accomplished at NASA, that seemed to imply that to one day for people to go to the moon, or to establish a colony there, those types of ambitions come from a generation of younger people.
An estimated 14% of NASA's workforce is over 40 years old, according to a Zippia analysis.

"That's not where innovation and excitement comes from. Excitement comes from when you've got teenagers and 20-year-olds running programs,"

One could argue funding is a huge obstacle to such an achievement, but that same generation they want pushed to the side are the same individuals who went to the moon, have sent rovers to the moon to study it, and came back with the data that the moon is one of the most harsh places in the planetary world. It consist of dust that sticks to every things, full of craters, is exposed to deadly solar radiation from the sun for a number of days before that flips to being for days one of the coldest places anywhere in the world when temperatures dip 200 degree Fahrenheit. Sensibly, logically, the older generation has concluded the moon is an uninhabitable place to exist and there's likely never to be billions, let alone trillions of dollars that is going to change that. On the flip side of that, even if they could, the alternate question involved would be who would want to live there, they have to build a completely enclosed city where people's lives would consist of looking out windows of vast darkness for days, and closing those same windows for days upon a time while dangerous solar rays pours down over them. There's no rivers, streams, lush green country sides, beautiful sky filled mountains or vast open oceans to sail upon, it would amount to be worse than living like a caged animal. But let's push aside the naysayers who aren't really naysayers, they are the voices of experience who once had the same dreams. You can build upon shared visions of hopes and dreams, but can't when one squashes them out. You are a highly intelligent man, tarazkp, I wouldn't sweat it at all myself that you are going to come out just fine, best wishes.