No, I wouldn't worry about the player with CDs at all. More expensive DVD players are usually a consequence of 1) video processing technologies 2) connectivity 3) name and/or 4) some slight audio upgrades. Most if not all reasonably priced DVD players from major brands decode CDs right at their theoretical limits. Then you have the choice of using the player's DACs or the receiver's DACs. I did a quick check on Cambridge Audio's website and it doesn't specify which DACs are used, but I'm confident that they're quite nice and that those in your Rotel are as well.
I have a Harman/Kardon DVD101 which retailed at $300 a year or 2 ago and it contains a superb DAC making its CD playback extremely competent.
Plus, if you really feel you're not getting all the sound you should out of the player, you can always buy an external DAC.
As for multi-room stuff, why purchase such nice equipment for secondary rooms? I could be wrong, but I can't imagine the speakers you'll be using in your other zones are nearly as nice or even worthy of such equipment when some less expensive stuff will perform MORE than adequately.