Water probably isn't grid connected like electricity. Nor does the supply need to perfectly match the demand every second. There is quite a bit of water storage in the system.
There might be pumps, in addition to just gravity assisted transportation of water. When energy is cheap, we can do both desalinate + transport.