Will a $700 turntable outperform a CD player?

As someone who has a SL-1200 MK2, and a Cambridge Audio CXC running into a Topping D90, I enjoy them both but have more of a fondness for the SL-1200.  I have done a lot of KAB upgrades and have a Hana SL cartridge on it, and it sounds very good to me; it keeps excellent speed and I never have the feeling I'm going to break it like I have with other TT's.  I think the cartridge makes the biggest difference.  Streaming Tidal still edges it out IMHO in detail and dynamics, but there are times where I will stream for weeks and then pull out record after record after record and be quite happy.  It all depends on your preferences, but I think you'd end up spending quite a bit more money and time with vinyl than you would with the Cambridge and a really good DAC - tt, cartridge, phono preamp, record cleaner (if you go that route), and then the vinyl itself.  If you're a thrift store shopper you can pick up CD's for next to nothing, but the vinyl that's out there is usually quite picked over.  I've found that my Cambridge CXC is very particular about what I feed it, in that any disc that is slightly scratched will behave badly in it - YMMV, maybe it's just my machine.  But I think you can't beat the noise level while steaming or playing a CD.