The earlier record sounds great, the later one pretty awful
If it’s not way-louder and “trying” to go over 0dB and clipping maybe it’s just the record.
If the analog line-level signal is too hot, that’s easier to attenuate than the direct phono-cartridge output.
Since your turntable (apparently) has line outputs, do you have a stereo you can try it with? If you don’t have a stereo with line inputs, you can plug line-inputs directly into regular “powered” computer speakers, or you can plug it into your TV.
I’d expect newer records to generally sound better than older records but I haven’t bought a record since I got my 1st CD player.
When I selected the “phono” input the recording levels were maxed out; when i selected “line” input they were at a more normal level, just ticking into -6.
In that case your turntable must have a built-in preamp (line outputs). That’s rare in a “traditional analog” turntable. It probably also has a switch.
If the turntable does have a switch, you can try bypassing the turntable’s built-in preamp, and switch-in the Behringer’s preamp. The odds are, they won’t have identical gain so one may work better than the other (and/or one may have more noise than the other).
Virtually all USB turntables have line-outputs and some have a switch to bypass the preamp, and some modern DJ turntables have a built-in preamps. In the analog-days stereo receivers had a built-in preamp (phono inputs) but that’s very-rare now.
The UFO202 has a built-in phono preamp (which you don’t need), thus the switch. (The similar UCA202 does not have a phono input.)
Phono preamps have two functions. They amplify the signal (voltage) by a factor of about 1000 (+40dB) at mid-frequencies. And, they apply [u]RIAA Playback Equalization[/u] which reverses the recording equalization by greatly-boosting the low frequencies an greatly-reducing the high frequencies.
So for example, if you plug a turntable into a microphone preamp you’ll get all highs and no bass. If you skip the preamp altogether you get all-highs and a very weak signal. If you run the signal through two phono preamps, you’ll get the opposite problem (plus clipping distortion from too much gain).