Will a $700 turntable outperform a CD player?

I’m looking into getting a second source as I don’t want to be tied down to internet and a streaming service as my only source.  Will a $700 turntable and inexpensive phono preamp out perform a Cambridge CXC transport / Schiit Gungir Multibit?  
The Schiit Sol / mani preamp look enticing but I know nothing about turntables.

I used to dj and always used technics Sl1200’s and really liked them.  I can pick up a nice SL1200 mk3 used for $600...

I figure that before I start spending hundreds, possibly thousands, on cd’s or vinyl, I should be sure which format I want!

Thanks for any advice / input regarding this 😁

Best Regards,
Bruce