You hit the nail in the head, with this one. The only way to do it at scale with solar power alone is already being done by the planet, through evaporation.

Desalination is energy-expensive. If you could somehow collect all the rain that falls over oceans, we’d have more than enough fresh water. That’s its own hard problem, though.