Regarding CDs, LPs, and streaming, I subscribe to Qobuz and Apple Music, and I also have about 10,000 LPs and maybe 6,000 CDs (adding more almost every day). And I listen to music through all those media all the time. But for different reasons. Streaming lets me hear music that I don't already own in a physical medium; CDs let me hear music that never existed on vinyl, and vinyl lets me hear music.
In terms of quality, the distinctions are extremely clear. On my system, which consists of PS Audio DAC and phono preamp, Well Tempered turntable and Soundsmith cartridge and Audeze headphones, vinyl offers more life, more depth, more feeling, more musicality than anything else, by a large margin. I found that CDs and streaming offered sound that was pretty equivalent--until, that is, I recently bought a transport for the CDs. I did that cautiously, not expecting much, and I was flabbergasted by the difference it made. Now CDs are to streaming what vinyl is to CDs: more life, more dimensionality, more flow, more musicality. And that's comparing redbook CDs to hi-res streaming and with a relatively inexpensive transport (an Audiolab 6000CDT). If I switch from a track streamed in hi-res from Qobuz to the same track on a standard CD in the transport, the difference is dramatic.
The convenience of streaming is very appealing, and the sound certainly isn't bad, but in my system and with my ears, there's more music to be had in physical media.