I, and several, family members, worked in the aerospace industry for decades here in Southern California. It provided good living to us, and I will never regret having been employed there.
Those were during the "golden days" of the industry, however, when cost-plus programs were the norm. Now, budgets have been slashed, programs cut, and interest in the space program seems to have flagged.
But, the slack appears to be getting picked up by billionaires like Elon Musk and Jeff Bezos.
This article elaborates and enlightens on the current controversy:
Astronauts explain why nobody has visited the moon in more than 45 years — and the reasons are depressing