Sorry about the vinyl. wasn’t even thinking of the media, more the method.
Flash drive data loss comes from two major areas. Read write process which depends on use is one source, and eventually, multiple reads, multiple writes, or erases will cause failure on a bit by bit basis. Recent developments in the technology might have reduced that by significant levels, but only time will tell, and the first ones using the new technology are barely on the market.
Discharge from incedent electromagnetic radiation is another source. Since that includes even cosmic ray bombardment, it is only partially amenable to mitigation by shielding. It is a slow, but inevitable source of errors. Decade long storage without use is probably a reasonable expectation, and this is especially so in data that are forgiving of single bit errors. (JPG, MP3, MP4, and similar data)
Both of these types of loss are also present in DVD disks, but are likely to be much lower in overall rates, except in highly controlled storage environments. (it takes more energy to alter the bit on a film, than in a chip.) For this reason, disk manufacturers are pretty secure in their multi-decade predictions. Stored, and protected, DVD’s are much cheaper per bit than flash drives.
Mechanical systems, which are prone to other causes of failure would be an additional source for magnetic disk drives. The actual plates have a slightly higher loss rate than DVD formats, but read processes by mechanical systems are much more prone to large volume data loss, over long term storage. It turns out that drives that have been shelved are only slightly more reliable than drives that have been used, for multi year long periods.
The lighthearted report about twenty year old flash drives was intended to highlight the fact that the entire duration of digital data storage, of all types is less than the expected lifetime of a book, in your livingroom. Estimates of centuries, still fall short of print media, many of which have lasted three or four hundred years, and some much longer. (Consider the Dead Sea scrolls, or any of thousands of Egyptian inscriptions.)
You want to save your music, or your photos, DVD’s will probably work for your lifetime. If you want to bury them in your Pyramid, maybe not.