CD-Rs will last longer than DVDs because the pits being written are larger. Further, audio can experience more degradation without perceptible impact.

I've had DVD-Rs fail in 2 years.

The type of DVD matters, of course. Here's a handy guide:

https://www.canada.ca/en/conservation-institute/services/con...