I’m taking bets that “Foundation” will be based upon a climate change apocalypse.
By the time Foundation starts, humans have left Earth long behind and colonized the whole galaxy, so I don’t see how they could even start to work “climate change” in.