Physical media isn't the ultimate format people like to make it out to be. I don't think there's anything wrong with digital media as long as it's files on a hard drive. Honestly, it's probably a better format for preservation than a disc that's locked into whatever video format it was published in. In 1000 years, it's pretty unlikely anyone will be able to read files from a DVD or Blu-Ray. But a file that's been reformatted to keep up with modern technology? That'll be useful.
CDs themselves only last 100 years at most. Hard drives also fail. There really isn’t a great solution for something permanent unless you are changing its form/format every so often
Hard drives fail more often than another computer component, at least the old-timey spinning hard drives. SSDs are better by far but I wouldn't trust important files to any single hard drive for long term storage.
Optical discs don't have that problem at all. They will be good as long as you keep them in a non-hot place out of bright lights. Heat and UV light and scratching are the enemies of optical discs, but they can all be avoided for as long as you care to keep them safe.
CDs don't last that long. I had a buddy that worked for a radio program tell me that the tapes lasted a lot longer. This was mid 2000s and he was already seeing failures. I think they were fairly early adopters, but still it couldn't have been that long.
Tape has been around for 80 years now and doesn't seem to be going away anytime soon. Copying to a fresh tape once a decade should keep your data safe.