Earlier quoted context omitted.
One thing that keeps me from trying tapes is that they are still magnetic. If there's some sort of local electromagnetic event then I'd prefer to have a backup that can handle that. I keep some backup hard drives in metal boxes, which is probably enough (Faraday cage). However, optical disks can almost certainly survive a major electromagnetic event without special precautions.
Interesting. Is a magnetic event more plausible for you than other types of decay? I'd expect physical damage from something like a flooding to be much more likely than some sort of magnetic interference. But that probably depends on the location you live in!
As wtetzner said, it's unlikely that a single event could cause all of these to fail. An EMP attack might take out my magnetic hard drives and SSDs but leave the optical disks unaffected. I've also had a hard drive fail due to impact damage that likely would not affect a SSD. Flooding is not something I've thought about before, but since my backups are located in different geographical areas, I should be covered there. Etc.