Automatic failover is like data backups, if not regularly tested it's like it doesn't exist.
I've seen backups and failovers not work so many times that it's an amazing surprise when one actually works--usually after laborious manual off-script intervention and invention. I was being somewhat kind to failovers, I have seen smallish backups work on several occasions. An untested disaster recovery is the worst.
Edit: think of an unexercised procedure as not "It works for me" but rather "it worked for me once."
On a failure, it might work. But there might not be a failure. Same difference.