If you go to System -> Preferences and open "Removable Drives and Media", then click on the Multimedia tab at the top, you can change the default behavior for when an audio CD is inserted.