I suspect something similar will hold true for agriculture. Farmers will plant different crops 50 years from now than they do today.
I'm skeptical of tipping points. Right now, I'm taking a "just what I see in the data" approach because of how politicized everything is.
I don't know what the future holds, but I'm not convinced, yet, that it's going to be a complete catastrophe.
We'll move the corn potatoes and Roundup, but nature will have to manage the rest. If a few keystone species go who knows what havoc will be wrought.
Fortunately, with recent progress in renewal energies, achieving a massive reduction in CO2 emissions does not require hardship, just a larger investment program (which will pay even off long time for most countries, due to no more money drained from the economy for oil). This investment would be comparable to the building of the US highway network in the 50ies and 60ies. Long term it was a huge boost to the American economy.
Houston is America's 4th largest city. Turning it into Detroit would absolutely be a hardship. We should still do it, but we shouldn't pretend that it won't cause suicide and violent crime.