It's all about how the water is made to move. An air pump is the least efficient because of waste heat. A water pump moving water within the larger mass needs to be large to have sufficient effect, as you point out.
But if you use a solar pump to remove water from the larger mass, and run it...