It might work in certain locales (lots of sunshine plus solar panels, perhaps), but the costs will always be high, and it's going to be very uneconomical for agricultural-scale needs.
https://www.scientificamerican.com/article/slaking-the-world...
I've recently seen a video on YouTube where they did this. They dug a "hole"/artificial lake with a capacity of over, I think, 140 million litres.
They used that to create "a wet spot" which slowly started to transform the surrounding landscape. Plants, trees, bushes obviously started from around that lake but moved farther and farther from it as the soil became better.
This does not solve any problems with salt water, but it could possibly a solution for areas where there's "only" very little water available.
Could we grow things like almond trees in large concrete basins and collect any water not used by the roots?
Keeping the water near the surface just results in more evaporation loss, and side effects for soil quality like concentration of salts.
Water infiltrating the ground will keep the soil "primed" for water absorption and storage, and prevent runoff and erosion and flash flooding. (Think about watering a potted plant with completely dried out soil.)
Plus it will just go towards recharging the water table.
Edit: My point being you don't have to supply 2MJ of energy, you need to move it. That can be done for less.
Understood, but the point is still that you need to keep something cold enough for vapor to condense, while the condensation of 1 kg of water is dissipating enough heat to bring 5.4 kg of water from 0 to 100C. Even if just moving the heat around, there's just too much of it.