For sure, home long term storage should be mechanical drives.
At the bare minimum most if not all the data can be recovered if not encrypted.
Flash storage is pretty bad and speaks volumes from say ROM on old video game consoles that still work to this day.
Anecdotal report: Files, some been there for at least the last 15 years, on my 20-year-old 128MB flash drive are still intact by the time I pulled them out couple years ago. Seems like they don't make them like they used to, even the not-fake ones. I wonder whether some of those no-name chips and microSD cards are actually salvaged. Some of those perfectly good SD cards in discarded phones must be going somewhere.
On the other hand, The ROM chips on old console carts will probably survive anything short of a nuclear EMP surge, being programmed quite physically by burning fuses on silicon or even dedicated lithography masks during manufacture. Newer carts with flash storage I'm less sure, though there are said to be some sort of refresh mechanism even though they cannot be rewritten as long as they are plugged in, for at least some of them - Wonder if we'd see reports of, say, Switch carts dying left and right in a decade's time, making them literal bitter pills to swallow.
I've been returning to physical copies for the most-irreplaceable and most-likely-to-remain-relevant data that fits the case, like family photos. Even a 2+1 backup setup has its limits, even on mechanical drives.
Still, putting any sole copy of anything you wish to keep on a flash drive is probably not a good idea at all.