I rarely burn DVD Double Layer discs, so I can’t provide you with real life experience in how durable they are over time.
A DL discs is more complicated to make than an SL disc, and the DL disc is harder to read because of the two layers with reduced reflectivity and contrast compared to SL.
So there are more things that can go wrong with DL media, and less degradation of the marks burned on the disc is needed before a disc becomes unreadable.
So in theory, an SL disc should be less likely to go bad in a certain amount of time if all other factors are equal.
If this translates into a real-world problem can only be answered by experience.
For data I wouldn’t personally choose DL for archival given the theoretical advantage of SL media. I would also choose to archive on two different types of DVD media or DVD media and another type of storage.
For DVD Video I might choose DL if that’s more convenient given the size of the original material, and have a second copy on something else.