The failure of CDs seems to be more of a case of marketing getting divorced from science. We’re never free of the constraints of the physical world. As an archivist will tell you, we have to simple adapt – from duplication to climate control.
But I’d say generally, with network-connected storage and automation, digital preservation is now better than ever. The failure point is humans; if you think about this stuff, you can solve it.