I looked around iTunes and SystemPreferences (you could turn that off in QuickTime Control Panel in OS 9), but it seems there's no option to turn this off.
Fortunately, TinkerTool gives you options to play (or not to play) Music/Movies CD/DVD when they are inserted.
I suggest you download it. It's free and gives you many other options.