You don't seem to have read your own link.  Pumped storage dams are quite small.  Electricity from solar, wind, nuclear and solar is "stored" by using the electricity the other systems generate to pump water into the dam for future use.
This has nothing to do with Site C.