Eeeeh, I don't think there's really a right/wrong answer here (except for never using solid state for anything you're going to power down.)
Bitrot sets in at about the 20 year mark for some older burnable discs.
Can even be an issue with commercial data discs, which is why I'm involved in a project to obtain, copy and archive unpreserved CD ROM software from the 90s.
Spinning rust disks are pretty good in the long term, if powered down, but there's fundamentally a situation where, whatever you store media on, you need to move it every 15 - 25 years.
Blu-ray might be our best long-term storage medium, but we just don't have the data yet, and it costs.