In most cases, music will mask the noise at those levels. And it's not so much quiet tracks, as the frequency range that is playing. With a turntable/LP, the noise is often also at lower frequencies. Solo instrument with no bass will show up noise because it isn't masked. Even then, the low level noise need not be obtrusive. You're still better off with digital and losing the other compromises inherent in LP, though, as long as the master is OK.
The range used for LP is still a good target range for domestic recordings, though. Not because of pain levels and such, but simply because it allows us to hear the music sufficiently well in a domestic environment without ruining our neighbours' lives. And classical CDs, largely, play within a dynamic range on a par or slightly greater than LP for that reason.
Too many digital masters of "commercial" music are not made for us - but for listening in difficult conditions, because so many people listen while travelling in different ways, where background noise levels are higher.
It's the dynamic range - and often the noise - of the recording that counts, rather than the medium, especially when using speakers in a room.