At-least in small-scale boat water making setups, the limitation is energy use of the pump. If you put it deep underwater, do you not remove the need to even have a pump, thus it will require almost zero energy to operate?
Way less energy, apart from the challenges of operating at depth. There would be power delivery constraints, and the basics of plumbing.