Welcome aboard. Keep in mind that there is a curve (and I highly recommend you go through the Mandrake docs on day to day use...fantastic documentation).
I use xmms. It plays CDs, WAV, MP3, OGG, etc. It only has a few thousand neat plugins to play with (Expanded stereo at 2.5, couldn't live without it), and several hundred skins. There are others, but I like/got used to xmms and what it can do. You can check out this link for a great one stop shopping place.