Yes that is also an issue, but generally it will be less prone to corruption than your SSDs, flash drives, or SD cards. Honestly nothing consumer grade besides optical media are particularly reliable as archival/cold storage unfortunately, but if I had to order them it would be Optical > HDD > SSD >= Flash Drive = SD Card > MicroSD.
This seems like a reasonable order.
Western Digital had a slide basically summarizing the faster the fundamental media is in terms of access times(us and ns), the retention times get shorter. So DRAM has almost zero retention time(it needs to be refreshed), than Optane was 3-6 months, then you had NAND SSDS that are rated for ~10 years.
USB flash drives are ridiculously cheap per GB so they use really low quality flash everywhere, which doesn't help with retention. So think of highest quality NAND going into Enterprise, then average ones into SSDs, and lowest quality that they would otherwise junk going into USB flash drives.
Optical can be pretty good too, but I heard like many things you have to keep them stored in a cool place away from sunlight because it degrades exponentially faster otherwise.