Sounds like we would need “smart” water heaters that can query energy prices. That most likely means they would be online sharing all kinds of data most of us probably don’t want shared and would have a small monthly fee. The water heater might even be very inexpensive because of this.
I know it wouldn’t have to be implemented this way, but of course that’s how it would go.
These days, rates can be more flexible thanks to "smart" meters (communicating via PLC). Just after the russian invasion of Ukraine, there were plans in place to open the dry contacts of customers outside of the scheduled hours in case the electricity grid needed to shed extra load. Thankfully this didn't end up being necessary.
What I'm saying is that you don't really require smart end devices. Put the incentives in place (deep discounts) and the rest will follow. You probably need at least one smart device to control the others if a timer is not enough, and I think the electricity meter is a good fit for that role.
Few households use more than 80 gallons of hot water per day which is still within the normal range of hot water heaters. Just add a timer so it doesn’t kick on until powers cheap and you’ll be good to go. At least assuming your cheap electricity window is long enough to fully heat the water.
This is one of the reasons people overestimate the need for grid energy storage. People time shift electricity to the night because it’s cheap. If it was cheaper 10AM-4PM then significant demand would shift to that window.