It is true that vinyl records have a smaller dynamic range than CDs and digital streaming, but it can also be a blessing in disguise on account of the loudness wars. A lot of modern digital music since the 90s have been brickwall mixed so they can be played on devices with inferior speakers or headphones and still sound loud and punchy, but that same music will sound awful and distorted on proper hifi systems.

Because vinyl records have a (slightly) smaller dynamic range they have to be mixed and mastered separately from CDs and streaming, and some times that means the vinyl edition has the only properly mixed sound. And even if the vinyl version gets a brickwalled mix, then it is still slightly better than the brickwalled CD or stream versions simply because the dynamic range capability is lower, so the brickwall is smaller so to speak.

Anyway, even compared to non-brickwalled CDs or streaming, vinyl still holds it own on proper hifi systems, there is nothing wrong with the sound experience under the right circumstances, and it is that combined with the physicality which is the draw for most vinyl collectors I think. It is inconvenient, expensive and often times inferior (especially if you find scratched up used copies), but that is exactly the attraction. It makes listening to the music an event.

Most vinyl record collectors still listens to other formats, because of course in the car or some other place you are forced to, so it is not an either/or situation either.