Im not an expert on the topic, but Malcom and Simone Collins have done quite a bit of research on the idea of this future, and in their book they state the chances are really low that it will happen on earth. They talk about why in their book, but you could probably get them to talk more on your fav podcast. https://www.amazon.com/Pragmatists-Guide-Crafting-Religion-Demographic/dp/B0BSJ5SXK2?ref=d6k_applink_bb_dls&dplnkId=f4ace579-7b87-4240-b53f-4ca0f366c57d

That seems like a very balanced response, actually. If it beats despondency.