VS HDD seems a bit unlikely. The typical cheap optical media isn't designed or meant for long term archival. There are more expensive types that are meant for long term storage but I'm pretty sure that's not what OP is talking about, especially if it's just random blank discs from thrift stores, etc.
But to your point even cheap optical media might outlast SSDs since those tend to lose their saved data if stored unpowered for x years.