If you’re serious, you could probably automate this right now with your DNS provider and uptime monitoring.
There's a huge difference in changing nameservers for a domain and simply changing host records.
If you want CDN-independent automatic failover, look into anycast with two providers. If one of them is Cloudflare, use the tier that lets you manage your DNS elsewhere.
As I said to the OP elsewhere, he should be doing something like anycast to multiple CDNs if this is critical.
DDoS attacks are extremely common at just about any scale, even if you only have a few thousand users.
Cloudflare going down like this? Actually first time I remember it happening. There’s been downtime before but nothing so major.
It's trivial to scan the whole IPv4 internet to find out which IP you are hosting your site on.