Automatic failover is like data backups, if not regularly tested it's like it doesn't exist.
On a failure, it might work. But there might not be a failure. Same difference.
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."