At the time, the US believed the USSR/communism was an existential threat to our way of life.
Beating the USSR to the moon, beating them in proxy wars, etc was all part of larger effort to ensure capitalism won. With the collapse of the Soviet Union, that external motivation evaporated.
I also think that Apollo was EXTREMELY risky by modern standards, and that risk was paid for many times in many ways.