The spec only says the dns IPs should be specified in preference order. Nothing says to treat it as primary and failover.
I've got her on an exclusion list because she just cares about being able to click on Google ads also known as "search results".
But I might not have added her on the backup Pihole now that I think of it...
If you can guarantee that the PiHole will always be fastest, it should be OK. But I'd be curious to see how you'd go about guaranteeing that.
It’s an approach I assumed would work when I did my first setup, but since there’s really no such thing as primary and secondary (or tertiary) resolver, I quickly realized it did not work consistently on most devices.
Turns out the Pi-Hole Raspberry Pi had borked and wasn't answering at all, my computer was waiting for the primary DNS _every_time_ for multiple seconds before trying the secondary one.
What it should've done (IMO) is query both and pick the fastest.
Swapped to NextDNS and haven't looked back, I set it on my router and mobile devices once and that's it.