Al Gore was definitely prescient in naming his documentary inconvenient.
Climate change is as much a human problem as it is a geophysical one because that psychological defense mechanism that you anecdotally describe in the face of existential gloom is universal to our species, and the cause of so much ill-placed skepticism and hostility toward climate science and its communicators. Don’t Look Up also did a good job at portraying this unfortunate human bias.
We as a species are too smart for our own good; smart enough to geoengineer our world to the point of threatening its existence, but not smart enough to address our own resistance to change and take collective action where and when it’s urgently needed.
For those who study climate change and those who try to mitigate it, there is this double burden of not only losing sleep over the magnitude of the existential threat, but also facing the moral and psychological failings of those who refuse to see reality for what it is and argue against it. It’s tiring.