For equally quality systems, in general, a red book CD is indistinguishable from the streamed version on my system. This was true for my previous system as well. Perhaps there are a few that have different files being used… but that is an exception not the rule. if I absolutely love some late 1950’s jazz I’ll pull out my vinyl copy, which gives me the last word in fidelity.
I use Qobuz, but used to use Tidal. This is not a question of one sounds terrible… they sound very similar… you would have to spend a lot of time to come up communicable differences, your equipment choices are going to make much bigger differences. But Qobuz has more high resolution titles. The high resolutions versions generally sound better than red book. But the most determinant factor of how good the sound is, is mastering. I frequently lift my head and go, “wow, what a spectacular recording”. About half the time it is a red book cd quality.
So, with good equipment, streaming just trounces a CD player. Not for every album sounding better, though many do, but for opening up the whole world of music and much of it higher Rez. Most importantly you can stop re-listening to the same stuff, because “you own it”. It opens up the whole world of music! I occasionally listen to something again… but nothing like I used to. The streaming interface lets you “collect”the stuff you want to re-listen to so it is easy to find. And, you have to… I probably listen to three new albums a day.
So, if you are going to put effort into digital, put it in streaming. It is what you are most likely to be listening to for the rest of your life… that and vinyl (if you are into that). Well done streaming is going to sound the same or better, but open up the world of music. I have 2,000 CDs working as a diffuser on a side wall… and dust collector.