CD-i was sort of ahead of its time, a DVD player avant la lettre. Unfortunately it being a console and ahead of its time, it was severely limited because of several things - too little internal disk space and working memory, and a 1x-speed CD player.
Animations on the console look terrible, unless they were made for consumers who also had a video card.
Music often doesn't play during games.
Controls are horrible on older games - vertical and horizontal movement is fine, but diagonal movement takes twice as long.
Loading times are infernal.
I did sort of enjoy the third Zelda game, Zelda's Adventure, and more than the other two Zeldas because you don't have diagonal bats flying in that you can never hit because of the bad diagonal controls - but because it takes several seconds to load a new screen, which you have to do all the time, it's highly frustrating.
https://www.youtube.com/watch?v=wnKLtY9SQU0