What numbers we have show that failure rates are low, but honestly I would give it another decade or two before using SSD for persistent data storage (of important data without backups to rotating disks). I don't think we're there yet.
Alternatively you could get a NAS, they are great.
Life experience has taught me not to trust detachable drives at all
The primary issue is not the 10 to the minus X failure rate they quote, but the much more likely chance that you will lose access to the data for some reason. For example, the account is hacked, someone closes the account, or the account just deleted/restricted by the provider.
But I’d say it’s unlikely that your local copy and the cloud backup would get destroyed at the same time.
Also, when I said “cloud”, I meant a proper cloud service with an SLA like S3 Glacier, not Google Drive which gets wiped if your Google account is disabled for uploading a YouTube video with background music.
I wouldn’t recommend relying on a single drive for long-term storage of anything that’s worth more than ~$1000 - neither with SSDs nor HDDs. Freak accidents can happen with any component. You PSU can go rogue and fry your SSD, etc.
The best option is most likely a single local drive with continuous mirroring to a cloud service. The drawback is the ongoing cost of the cloud, and the possibility of partial data loss, because cloud mirroring won’t be instantenous when saving bulk data.
A local RAID1 array is cost-efficient, but doesn’t save you from black-swan events like floods or house fires.