CD/DVD only have long lifespan if you buy good ones and store it properly. You might as well as buy specific storage which specially designed for long term archive, such as M-Disc or SanDisk Memory Vault.
I checked both of them that's too much for the human lifespan unless you can live more than 100yrs or only if you have family that you can inherit.
Cd/DVD discs are enough for me to hold my coins for the long term. Since Bitcoin or money, you can't take them with you when you die.
M-disc would be a great deal it has 1000yrs of lifespan this would be a nice option if one of your grandchildren is your heir of this backup for future holdings.