I've always thought that the public reaction to aliens in Contact was precisely, painfully accurate. Panic, cults, religions, the typical human response to something huge, unknown, and unknowable.
The same richest elites that refuse to acknowledge and do anything to revert climate change, will do nothing (except try to escape Earth in spaceships) if and when any humanity detects and anticipates any Earth destroying apocalypse inducer (asteroid/meteor or extreme solar flare) from out of the depths of space.
To a more naive, metaphor-blind audience, your mention of Don't Look Up makes it look like the scientists are warning about an alien comet and I'm the one ignoring it.
I'm very familiar with apocalyptical narratives of all kinds, but what I'm approaching here is much different. I'm talking about the integrity of scientific endeavours. In particular, space exploration endeavours.