You would need several Sonos amps for this situation. Each amp is designed to cover a single room/zone. It has connections for a single pair of speakers, but you can connect 2 pair of speakers (same volume and source) with typical 8 ohm speakers.
As far as inputs go, each amp has aux RCA, which would work with your CD player. They also have a HDMI-ARC port to connect directly to your TV. That would cover your TV and DVD player (DVD player and Apple TV connected to TV). And of course, the amp can stream music services directly or play tracks from a local library. Each Sonos amp or speaker can play it’s own audio source, or be grouped with other Sonos devices to play in sync. That includes the CD player and TV audio. You can also add Sonos speakers to additional rooms in your home to be play along with your ceiling speakers.
it’s hard to say exactly how well Sonos will fit in with your existing system and goals without more information. We don’t know what TV(s) and speakers you have or where your wiring is. But it does sound like it would be a good fit for you.
Although I hate responses from customer support reps that immediately begin by asking for more information without offering any help, it’s necessary in this case:
What model keypads, and which model main distribution box? oEdit 2: Oops, double-sorry, you said “CAM 6.6” in the title. Which keypads?]
(Some speculative help, knowing nothing yet: The hard part will be your requirement, “able to use the in wall controllers”. You mean the existing ones?!? The rest, incl. multiple inputs, is easy: 6x Sonos Amps, whether room-local or central daisy-chained ethernet where your Russound box is, will give you 6 analog (or digital) aux input sources, with auto-play if desired. Again the local sources, like the keypads, is the tricky bit -- if the only access to the speaker wires is centralized thus the Sonos Amps have to all be inside some equipment closet… Thus more info is required, see above!-)
qEdit: Slow typing. Same as above!]
nEdit 3: A completely different but obvious option is using a Sonos Port as an additional input to the CAM6.6, which will let you keep your existing keypads, and just carry around an iPad Mini to control the Sonos. Knowing how you are running your AppleTV now, and what you ideally want, would guide the answer.]
