And the reality is, intermittent power can never form the entirety or even a significant portion of a grid, because it would be too unreliable.
Tidal (pumped or not) and pumped water storages can be a viable solution to the intermittent renewables but at the cost of reducing their sustained capacity.
Tidal power can never be a major source of power, so its intermittent nature is not an inherent constraint to its use. Tidal might be a useful part of a total mix of energy sources, in certain specific places, but the planet's total tidal power is not sufficient to meet human needs.
Tidal works in places like the Severn in the UK. The global tides are less than one metre, varying with the relative positions of the sun and moon. They are largely predictable, which is a really good quality for an energy source. Its wrong to say tidal is unreliable. You know when its going to be available years in advance, and you know the approximate amount of energy you are going to get. Its just intermittent. The big snag is the energy is spread over vast distances, and the water head is small. Take a place like the west coast of the UK or France, and tides are magnified by the continental shelf. Add the effects of funnelling the water into spots like the Severn, and tides can be 8m to 10m high. Now you have the kind of concentration of power which can make it useful. Its a resonant effect, though. If you want to extract energy from a resonant system, you need to work in sympathy with it. Fight it, and the energy dissipates. This is why talk of time shifting is a non starter. You can nudge the timing by a small amount, but if you try to move significantly away from the optimal timing, the total available energy rapidly drops. Some people have written as though the goal is to get a dribble of energy 24 hours a day. If you aren't getting a lot of energy you could never justify the resources needed for construction. You probably wouldn't even have a net energy benefit, after you amortise the construction energy consumption over the system's working life. Any required barrage should have a long life, but the expensive equipment won't. Mechanics doesn't life variable operation. Just compare the few thousand hour life of a diesel engine in a vehicle, with the 25 year life a diesel engine in steady 24 hour use can offer with reasonable overhaul cycles.