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.