The water needs to go somewhere to generate power. Most water tables are much closer to the surface than 1000 meters. Meaning, the water would have no way to go without pumping it back up...
That is where the storage presumably comes from, you use the excess energy to pump water out of the hole. I think the whole thing would be just as geology dependant as the conventional arrangement but with the added expense of digging down 1000m.