Come on. The US did not go to the moon because millions of Americans banded together and sacrificed around a single goal. The US went to the moon because the government felt capitalism was losing the PR battle to communism (Soviets) and so decided to pour money into it because they didn’t want to look bad. https://en.m.wikipedia.org/wiki/Space_Race
"Action on climate change" very vague... mostly that is "get more electricity from renewable, maybe get an electric car". It is nothing that reduces the quality of life, that is supported from very few people, almost none. There is reasons the answer to how to fund is always "make the rich pay", Americans do not like paying for stuff.