Well, the short answer is that I would wave you off of CDs right away. For something that important, I think other solutions are called for.
As I’ve discussed before, the continual progress of storage technologies is an ongoing issue. What we choose today might not be appropriate in a few years or a few decades.
Rather than tell you what you should do, let me tell you what I do in case my photographs are ever of interest to future generations.