I keep raw files on the storage cards for some time, as Lightroom will anyway avoid duplicating them on the hard disk.
I empty the cards onto an external, RAID 1 HDD. That sort of drive has been my primary storage for years.
Processed files are on my laptop, replicated on the cloud.
When I upgrade the external HDD, I copy all "old files" (easy, given Moore's law), but I leave these on the old drive, just in case.
No fails so far. I have applied the same tactics to concert recordings.