I stream mostly from my NAS to my Roon endpoint (PS Audio Directstream DAC) via fiber optic using gigabyte wifi/internet. I also have a Qobuz subscription that integrates nicely with Roon (used mostly to explore other music before I buy it). In my case the sound quality of the CD might barely edge out the streamed version (less potential interference or things that can go wrong with the data stream including processing), but not enough for me to be concerned about it. I’m also more engaged with the music when I pull a CD off the shelf - a better listening experience for me overall. I’m not convinced that Hi Rez always sounds better than standard CD resolution either for various reasons, but that is another debate for another time.
CD v Streamed
Uncompressed CD audio will take about 10.6mb per minute to play, to stream that takes big space and dollars to stream an album, see what your streaming company’s takes mb per minute to stream, find out and post up here.
I hear CD’s are better, I get better dynamic range from CD every time it’s A/B to me, now that could be that the streaming companies are using the "later compressed re-issues" of the same albums, you can find that out here https://dr.loudness-war.info/
Or that the streaming process itself compresses the music to save "streaming size" to save big dollars even if in small amounts.
Here’s a video from the CEO of Disc Makers Pty Ltd, yes he probably also biased because he manufacturers CD’s and vinyl, and is a very bad dancer.
https://youtu.be/YHMCTUl2FQo?t=1
Cheers George