Apollo really was a rare alignment of motivations, unbounded optimism meets existential fear, ie, "humanity can migrate into the stars" overlapping with "if we don't do this the commies win first strike capability", seems unlikely to re-occur.