Or, instead of building a national water grid and thus another piece of incredibly expensive infrastructure that you won't find politicians willing to maintain

Or, instead of building a national water grid and thus another piece of incredibly expensive infrastructure that you won't find politicians willing to maintain 30 years from now, you could abandon areas like SoCal that are clearly becoming unsuitable to sustaining life. It's going to happen anyway, why not get a head start?