Pumped storage isn't really hydro, just storage for other generating capacity.
Hydro potential for a country depends on
1. Rainfall
2. Land area
3. Elevation.
We've got lots of 1, not so much 2 and bugger all 3 compared to say, Norway or even France. There's little potential for more in the UK and certainly not in England.
Tidal at scale generally relies on the construction of humongous lagoons eg Swansea Bay, with accompanying costs and environmental impacts.
https://en.m.wikipedia.org/wiki/Tidal_Lagoon_Swansea_Bay
Micro schemes, whether hydro or wind, whilst good of themselves, don't have the potential to impact at UK wide scale.
Solar gives minimum output when demand peaks, so you either need backups for winter or massive redundancy.
The good news is we've got lots of wind, and, that leccy cars are so efficient they use less than petrol cars even if their leccy is generated from fossil fuels and that smart charging of them can help level demand.