Which CD player with radio (ideally bluetooth as well) to connect to Sonos system

has such increased my use of CDs, rather than reduced that use.

And in direct response, while I understand the attraction of being able to handle the CD and read the liner notes, my experience is just the opposite. Or more correctly, it is the same as yours, but is so because I no longer use CDs, only their ripped content, and here is why:
In my case the 80/20 rule worked very powerfully when I used CDs - indeed over half my collection may not have seen use for years! Simply because there were so many CDs, that it was easy for these to physically stay out reach and out of circulation.
Once I had finished the process of ripping all of them to a NAS - about 1500 CDs - it was easy to access any of these effortlessly. One way that I use their content now is to make playlists of these by genre. Once the playlist is loaded, and random shuffle is selected, over time, every CD will be automatically played if, as I do, the loaded playlist is never deleted. I merely use the start/stop button every day on the playlist.
By the way, my ripping project started some years before I bought into Sonos - for having access to the CD content on my iPod, so it wasn't a one time major effort to be done just because Sonos came into the home.

I think there are two types if Sonos user (there maybe more): 1) those that purchased Sonos to allow them to play music in ever room and 2)those who want to have that facility plus the need or desire to have CDs and vinyl replaced and fully convert to digital and streamed sourced.

So, just for balance, I thought it worthwhile making the OP aware of the first as an option, as I didn't think it clear from their post what their direction of travel was going to be.

has such increased my use of CDs, rather than reduced that use.

And in direct response, while I understand the attraction of being able to handle the CD and read the liner notes, my experience is just the opposite. Or more correctly, it is the same as yours, but is so because I no longer use CDs, only their ripped content, and here is why:
In my case the 80/20 rule worked very powerfully when I used CDs - indeed over half my collection may not have seen use for years! Simply because there were so many CDs, that it was easy for these to physically stay out reach and out of circulation.
Once I had finished the process of ripping all of them to a NAS - about 1500 CDs - it was easy to access any of these effortlessly. One way that I use their content now is to make playlists of these by genre. Once the playlist is loaded, and random shuffle is selected, over time, every CD will be automatically played if, as I do, the loaded playlist is never deleted. I merely use the start/stop button every day on the playlist.
By the way, my ripping project started some years before I bought into Sonos - for having access to the CD content on my iPod, so it wasn't a one time major effort to be done just because Sonos came into the home.

Kumar,

Fully understand what you are saying.- I too have ripped the vast majority of my CDs, originally to iTunes, and now also accessed by Sonos. And, I have hundreds of playlists that are regularly run and enjoyed. Like you, this has been a project that I have been involved in for any years prior to Sonos.

But equally, that doesn't mean I am going to get rid of my collection of CD or vinyl because, as a collector, I want a physical manifestation of the music, especially for some of the major artists that I like. It's far more important to me to have a CD or vinyl album of my favourite artists, that it is to have that as a digital track.

My pleasure is more in playing the physical, that there is also the added flexibility of playing the digital for convenience.

As ever, there is never a one size fits all approach.

as a collector, I want a physical manifestation of the music, especially for some of the major artists that I like. It's far more important to me to have a CD or vinyl album of my favourite artists, that it is to have that as a digital track.

No argument with that; I behave in the same way with my extensive collection of movies/TV shows, and I am sure that this says that neither of us can ever pass as millenials!

Yes, I think you have it there!!!