I was doing some work on my server and noticed that when pi-hole was down, I couldn't access the internet.
You've opted to take control over a critical piece of network infrastructure. This is to be expected.
There's a reason DHCP provides for multiple DNS servers to be listed. Having redundant DNS servers is a common setup. So yes, multiple piholes if you want stability.