Exactly this. Desalination and transport is aways orders of Magnitude cheaper and more efficient.

I don’t see this changing at any point in the near future. It’s phenomenally energy intensive to pull water out of the air in any quantity.