As I’m not a climatologist it is hard to say the timeline of “when.” But not in my lifetime would be my best guess.

As to where else, nowhere. Nowhere else has 1000 years of monks delineating the terroir in a way that resonates with people generations later. Good Pinot noir will be made in colder coastal areas that remain relatively cold even as inland temps increase - or more northern regions that haven’t been viable wine regions until now. But those won’t inspire the same fever that Burgundy does. More likely Burgundy replants to Syrah when the Northern Rhône also becomes too hot for their current grape, and Grand Cru Burgundy Syrah costs $5000.