Not an expert, but I have read somewhere probably the most effective use of this is to pump water back up behind dams - imagine you could pump water from the bottom of hoover dam using wind power or whatever. All the generation equipment is already there, so you sorta get that for free. Additionally with lake mead shrinking this might enable more hydro power from existing infrastructure even in the face of climate change.
What this means for water-rights downstream, I have no idea - probably not good.