Polling has consistently found that most people would prefer NASA spend money on things like monitoring climate change and averting asteroid collisions rather than human spaceflight.
Source: https://www.nytimes.com/2026/03/30/science/nasa-astronauts-moon-americans-mood.html