Look at the NASA budget as a % of fedral budget. For the Apollo program, the budget shot up to extremely high levels. After the program, the budget took a hit.
Soviet moon rocket (N1) failed and they accepted defeat. Space race was over, arms race was on. And the US did not return to the moon...