I have always been conflicted about the use of such sums of money but thought I remembered hearing the spin off benefits have been huge. A quick google reveals:
Key benefits gained from lunar exploration include:
Technological Spinoffs: Technologies developed for space have found extensive use on Earth, including, but not limited to:
Medical & Health: Improved imaging technology (CAT scans), advanced, lightweight prosthetic limbs, and ear thermometers.
Public Safety & Materials: Fire-resistant materials, water purification systems, and space blankets.
Computing: Miniaturization of technology and advancements in computer microchips, which are vital for modern devices.
Everyday Consumer Goods: Memory foam, scratch-resistant glasses, camera phones, and cordless electronics.
Scientific Knowledge: Lunar samples and instruments helped determine the Moon's age, interior structure, and composition. Understanding the Moon's impact craters has been vital to understanding the geological evolution of Earth, Venus, and Mars.
Environmental & Weather Monitoring: Technologies developed for space have led to better meteorological forecasting, aiding in tracking hurricanes and studying climate change.
Economic Returns: For every dollar invested in space exploration, the economy has historically benefited by a factor of 5 to 7.
Future Capabilities: The moon serves as a testbed for technologies needed to reach Mars, such as testing life support systems and investigating how to utilize local lunar resources (like water ice).
Inspiration and Cooperation: The Apollo missions revolutionized space technology and inspired generations of engineers and scientists, while fostering international cooperation.
The CAT scans will have saved so many lives, although I suppose nobody can know if those discoveries would have come from other means. They wouldn't come from investment in housing etc it would have to be in direct research. I found the bolded economic benefit quite surprising.