A RAID 1 array of spindle hard drives is pretty well established and is pretty good. I've never seen an entire RAID 1 array lost, but that doesn't mean it can't happen.
The reliability of SSDs is still a question mark in my mind. I've seen several folks on these Forums who've had their SSDs fail.
Of course, a RAID 1 array is also capable of scrambling data. I've had my Exchange Server's RAID 1 database damaged twice in six years by power outages (and, yeah, I had a UPS). Backups, not RAID, are what saved the day.