The public, for the most part, stopped caring about NASA after the US stopped going to the moon. Most of the rest believe NASA is hiding aliens or controlling the weather or some such nonsense.
Do you have evidence to the contrary you could share?
https://www.planetary.org/space-policy/nasa-budget#:~:text=N....
Many people have also written quite a lot about how the race to the moon was primarily funded because it was a military domination competition. Once the USSR decisively lost, the US stopped doing that expensive science. A good overview of the geopolitics of space exploration and research is the book Dark Skies by Daniel Deudney [2].
[1] Combination of ethical reasons and having to do security checks and your freedoms somewhat restricted.
[2] https://global.oup.com/academic/product/dark-skies-978019090...