Mind, where it does work, it's phenomenally effective, efficient, and responsive.
There are a few sites at which seawater-based systems might be possible, in which the ocean forms the "lower reservoir". These are dependent on suitable terrain. Matching terrain to consumption patterns is difficult: the Netherlands and much of Britain are sorely lacking. Some of the best potential sites are along the Balkan coast in Serbia and Croatia. Chile's Atacama Desert, along the Pacific coastline, is nearly ideal geographically, but is far from most use (North America, Europe, Asia). Portions of the US West Coast might be suitable, though would all but certainly face major political resistance for environmental impacts.
And: working with seawater is complex from an engineering standpoint: it's corrosive and sea life has a pronounced tendency to foul large-scale water-handling systems, though this may be tractable. There've been several pilot projects, though those have since been decomissioned, excepting Rance in France, designed as a tidal power plant, though capable of working as a pumped-hydro facility.