Do you mean actual mechanical pumping or are you confounding the water cycle in this which is what most people would call hydro power?
Pumped Hydro energy storage is the #1 energy storage in America, and probably the world. A single plant provides 24GW-hrs of energy storage, dozens of more energy storage than all American utility scale Li-Ion batteries combined.
Bath County is the biggest pumped-hydro battery in the USA (and probably the world), but there are dozens of pumped-hydro plants across the country.
------------
Turns out that all the water in a lake can hold a huge amount of potential energy through gravity: just pump it up a mountain.
Actual mechanical pumping.