A solution is there if we had the will to implement it: https://www.osti.gov/biblio/963122

Take excess water from SE floods and pump it west opportunistically using excess renewables. Bonus because you can use the pumped water as gravity storage.

Yes, it is not cheap, energetically, to pump water. Yes, you have to cross a big mountain range(which increases opportunities for gravity storage).

For some reason, this suggestion always gets a lot of comments from folks living around the great lakes who think we're going to 'steal' 'their' water(just like they 'steal' CA grown produce, I guess?).

Anyway, a national water grid is needed for national food security and can mitigate flooding damage in the SE(probably more important b/c of AGW).