I suppose many of the institutions responsible for national security are making worst-case analyses all over the world. Of course that research wouldn't be public.

As for the "naive pipe dreams" as you put it, I suppose being more pessimistic will soon lead you being labelled as a doomer and ignored. There is some material though, like Uninhabitable Earth by David Wallace-Wells. It's a depressing read.