It's definitely insane to think that changing the direction of water as it flows downhill is anything like pumping water up over the mountains.
The idea that californias water projects only direct water downhill is invalid anyway - the California aqueduct flows uphill quite a lot, and over mountains.
https://en.m.wikipedia.org/wiki/Edmonston_Pumping_Plant is one of at least 5 pumping plants along the aqueduct.