Having only one pi-hole on a Raspberry Pi, running for years, I can say that investing in some form of UPS has greatly offset the need for other 'redundancy' measures. I have never had an outage, other than one caused by my own 'tinkering'. Ensuring your OS, and the pi-hole running on it, shutdown and restart properly does wonders for long-term stability, IMO.
Agreed, same here. The only outage I have is electricity (and if it's long enough for the UPS to go out, I've already shut everything down gracefully anyway) or the ISP in general; if that's down, an alternate DNS provider isn't going to help.