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
128x128b_limo
Why such an insistence on either/or? I'm quite pleased by the various vinyl or streaming fashionistas who declare the cd dead, as they're loading up the shops with their discards. My collection grows each week as I raid the local record store; the proprietor, maybe the most interesting and knowledgeable guy, musically speaking, I've ever met says cd's are inconsequential to his concerns, even as he stocks the best selection I've ever encountered and prices classic cd's as low as a dollar. Vinyl may be his bread and butter, but his stock respects a much broader taste.  

I like vinyl very much, having recently purchased a table and a decent selection of good pressings of (mostly jazz) albums. But holy hell, the prices are exorbitant. $54 for a Three Blind Mice label record? $35 for an Impex Records pressing? I get that using analogue masters are pricey, but I have a mortgage and children's braces to pay for. And as paulburnett notes above, even poorly-done reissues, made from digital sources, cost silly money these days.

How about recognizing that "the more the merrier" makes good sense here, instead of claiming that "putting up with digital" is some kind of audio sloppy seconds? 

To reply to the question: It all depends, right? 
It seems like you need to spend around $2 towards a vinyl rig to equal $1 on the digital rig. That is my experience anyway. That is just the equipment. That doesn’t factor in the expensive audiophile pressings that really bring things to life.

That said, I prefer vinyl. I like the ritual of playing lps and love the sound. I’m way deeper (cost wise) into vinyl so I can out‐preform my modest streamer and DAC. I’m ultimately ok with this though. I guess it just depends what you like ultimately.
Definitely all depends. Some of my vinyl sounds better than digital and vice versa depending on release. CDs played on a good 21st century transport always sounds equal or better than the Redbook file. Many tracks are indistinguishable between Redbook & HiRez. I know what music I like and much of it is not available on vinyl. 90% of all recordings are Redbook. 
I’ve been playing records since 1965. That was on my dad’s Garrard and HH Scott receiver and Wharfdale speakers. I enjoy records immensely!

i also have CDs. I also have streaming digital sources. 

I dont spend a lot on vinyl, not on my (14) turntables, nor cartridges (82). I inherited 4,000 LPs from my folks. My mother worked as Quality Manager for Columbia Records pressing plant in California, 1955-1967. I’ve added just under 1,000 LPs myself. Mostly eBay and thrift stores. 

All of the digital sources I have only serve as an expensive convenience, and to verify just how good all the vinyl sounds. 

When i want REALLY GREAT listening, it’s from vinyl.

All this talk of spending $1,000s for a vinyl setup is absolute garbage. Not necessary. 

And, if digital is so great, why the preoccupation with searching for the best DAC? Absolute garbage, too! Don’t you know?? Digital is perfect already!
I have 5K CD's, and approximately 2K LP's. I'm not clear whether you have a CD collection and or an LP collection. There are many ways of looking at your question. How much past history do you have dealing with a turntable? If this is your first venture, you will most likely make bad choices, until you gain some knowledge and experience. The entry level turntables currently on the market. Will get the job done, ie. playing records with  a reasonable level of reproduction. On the other hand, if you own a collection of decent CD's and a decent player, you will most likely be disappointed that the LP nirvana that you have heard about, and are seeking, is not so easy to come buy. The fairly new SCHIIT turntable, which by the way is not that easy to setup properly, but in doing so, is capable of some rewarding playback, depending upon your choice of cartridge. Even though the SCHIIT is only $650.00, factory direct, you will have to spend at least as much as the cost of the turntable to purchase a decent cartridge that is good enough to avoid wanting to get something else in 6 months or so. And then there is the setup. Not for the faint of heart. Especially if it's your first venture.  So, unless you can increase your budget to a point where you have enough to invest in a TT package that will truly satisfy the question you pose. I'd stay clear of it for a while and stick with the CD format.  That pretty well sums it up