How does a beginner turntable compare to digital ?

I am thinking of trying my first turntable with a 300-500$ turntable such as Rega P1 or Pioneer. How does that sound comparing to digital playback ? For example compare to Rega Apollo CD player ? what kind of differences can I expect ?

I am using Rega Brio 3 amplifier and Harbeth C7-es2 speakers.
Excellent midrange is a must to me. I am listening mainly to folk, bluegrass, jazz, small chamber musics some ballad rock.