Looking for a good turntable

It might be a good idea to also look for Turntables with Bluetooth capability; google search should help. A small bluetooth receiver attached to the line in jack of the Sonos unit will allow such a TT to be placed more flexibly without needing any wires to connect it to Sonos.

I'd say go with a Pro-ject Debut Carbon DC. It's a perfect starter turntable and it just might be all you ever need. It's completely manual though (meaning you have to be there to take the stylus off the record when it ends). If you need an automatic, look at the Audio Technica LP120. Another good starter setup.

Keep in mind you may need to get a separate preamp depending on your setup. Personally I've got a Debut Carbon running through a Pro-ject Phonobox E preamp into a Sonos Connect. It works great.

A few more things to consider... the stylus makes a huge difference in sound. I'd recommend looking for at minimum an Ortofon OM5E. Even better would be an Ortofon 2M Red. Even better than that is a 2M Blue. It depends on your budget but get the best you can afford. Preamps matter too, you can start cheap but you will want to upgrade at some point.

Setup is important too. Make sure your stylus is tracking correctly and the tracking weight is set properly. With a bad setup the stylus rides along the side of the groove missing parts of the recording.You want it done deep in the middle of the groove to maximize sound quality. YouTube has some great videos on turntable setup.

I'd recommend against using Bluetooth for sound quality reasons . BT to wifi to speakers leaves a lot of places where you can lose quality. Vinyl records, if done right will give you top quality sound. Might as well take advantage of it if you can.

One more thing is with Sonos is you'll likely need to use the "compressed" sound setting to avoid drop outs in signal from your turntable. Compression is another small hit to sound quality, but it beats having the sound cut out on you.

I understand the visible engineering appeal of TTs; I had one for just that reason. I also understand the reason for one where one has a lot of records that are rare with music not easily obtained in digital form.

But digital was invented in response to sound quality issues that TTs suffer from, even when perfectly set up and playing a new LP for the first time. Over time, TT meanders away from these levels that digital surpasses. I have not found any LP to sound better than the equivalent CD and now CD rips. Perhaps I don't prefer the distortion that vinyl brings to the table, just as I don't prefer the distortion that valve amps do.

I sold mine once the hassle of changing records on it eclipsed the cool of having one; since I never had an extensive collection of LPs.

YMMV.

Obviously a turntable shouldn't be your only way to listen to music. It's inconvenient, it's labor intensive and it can be expensive. I have MP3s in my car, I use iTunes to keep my home music collection, I subscribe to Pandora and Amazon for streaming, but I still enjoy vinyl. Cigars are never going to replace cigarettes, but It's still nice to light up a nice Cuban on occasion.

There's something cool and satisfying to the hands on experience of vinyl. digital vs analog aside, they can sound great. Plus some of these turntables are works of art, nobody ever said that about a CD player. CD's are all but obsolete and there won't be a renascence in CDs anytime soon. CDs were invented because records weren't portable and digital surpassed the quality of cassette tapes. Plus you could quickly switch tracks.

Sound depends a lot on what you're listening to and listening through. Digital quality depends on the source and the transfer. A Cd is what? 320 Kbps? Rip that into a standard 128 Kbps MP3 and you're losing some serious sound quality. Different formats have better quality, flac, mp4s are better but digital is already starting with a compressed signal. Vinyl is a lossless medium. Of course getting the best sound from the record to your speakers is the challenge. We could argue sound all day but basically both formats can sound great or they can sound terrible.

If you ever wear out a record, your setup is way off or you're using bad equipment. A good stylus will wear out before a record ever will. Plus, if you ever played a record enough times to wear it out, you should probably spring for another copy anyway.

Vinyl records are fragile and listening to them is takes effort, but it's still a great way to experience music.

Digital quality depends on the source and the transfer. A Cd is what? 320 Kbps? Rip that into a standard 128 Kbps MP3 and you're losing some serious sound quality. Different formats have better quality, flac, mp4s are better but digital is already starting with a compressed signal. Vinyl is a lossless medium.
You make points about vinyl that are well taken, but not all are accurate.
Vinyl quality cannot get away from the need for quality source and transfer; Garbage In Garbage Out cannot be escaped by any one.
CD streaming rates are 1411 Kbps, but few can reliably distinguish that from 320kbps in a blind test that eliminates every other variable.
That digital starts with a compressed signal is not true, but that admittedly is a common misconception about digital audio. Digital can be as lossless as Vinyl. Digital was invented to better the sound quality obtained from Vinyl and the best of digital does that quite easily.
I agree that CD players and CDs are obsolete and digital tech has moved on from needing CDs as a media. While there is no replacement for the "cool" of vinyl, so I expect TTs to be made long after CD players aren't anymore. But not because they deliver superior sound quality compared to digital audio, but because people will still want the "cool" thing. A bit like people still wanting and using valve amps. Or fountain pens. Or hand wound wrist watches.
PS: a good comment I read once about vinyl: "Is a CD-quality album going to sound more accurate on vinyl than a CD? Nope. But it will sound more vinyl-y, if that's your preference."
One could say the same about a quality valve amp which will cost a lot more than an equally good transistor amp.

"It ain't ignorance causes so much trouble; it's folks knowing so much that just ain't so."

- Josh Billings, Humorist

Lol. A little knowledge can be a dangerous thing?

I can understand the cool thing and also the pleasure in being able to see precision engineering at work - something totally lost in going digital. I can also understand the pleasure in the associated rituals and making listening to music more involving as a hobby. If one can't play a guitar, playing an LP and keeping the TT/LP in good working order can make up to an extent!

But there is a price to be paid for these pleasures apart from the higher cost of the kit compared to solid state kit if it is to perform well. And using vinyl with Sonos, unless it is to access a large LP collection not easily available, seems to be a contradiction in terms. But if it floats some boats...

I've had a couple dozen TOTL turntables, from Dual, ELAC, Thorens, Empire, JVC, Pioneer, Technics, among others. None will ever match the signal quality of a digital source, but they can sound great, and can be fun to spin when the mood strikes.

The only one I've kept is a Sony PS-X65. It's from the early 80s, just before CDs started to take over. One of Sony's efforts to show just how great their engineers were. The TOTL at the time was their PS-X75, which added a computer controlled arm to the same base. I can't think of a modern production table that can come anywhere near the build quality or performance of these old Sonys for under a few $grand.

Plenty of great tables out there on Craigslist and in the thrifts, waiting for some love.