CD or Streaming... am I missing out?

Local files sound better to me than streaming, but streaming can sound enjoyable. The real benefit of streaming is the ability to switch music really easily and to have 100s of thousands of music tracks accessible whenever you want them. It's been a huge change in how I discover new music.

+1 to what @georgehifi says.

Streaming can sound quite enjoyable, it's just not quite as good as playing back local files and definitely not as good as vinyl. However, I find that in this year of COVID and working from home that I'm streaming most of the time, because it allows me to listen to music while doing other things more easily.

See if you like the idea of listening through Pandora. Just know that if you like the idea of streaming, you can get FAR better sound quality via Qobuz. Even Spotify Premium sounds pretty decent. (Amazon HiFi & Tidal do not).

My listening notes:

My subjective impressions of the musicality and sound quality of the major HD streaming services:

1. Qobuz
2. Primephonic
3. Spotify Premium (320 kbps Ogg Vorbis which is not lossless)
4. IDAGIO
5. Amazon HD
6. Tidal

Round 1, Spotify Premium vs Qobuz: I have Spotify Premium with a Family subscription. From a value standpoint, Spotify was my default choice that has the best search as well as working well for my family. From a critical listening perspective in my auditioning sessions, Spotify actually is not bad at conveying detail, pace and presence from music. It sounds musical. Any shortcomings that it has are errors of omission rather than errors of commission. I can listen to Spotify especially in mobile settings and be engaged and immersed in the music. After listening for a longer period of time, Qobuz is clearly better at conveying detail, transparency/clarity, pace and presence, but Spotify doesn't do anything noticeably wrong.

Round 2, Qobuz vs Tidal: So far Qobuz is clearly better than Tidal even listening through pretty cheap desktop passive speakers. Tidal sounds very two dimensional and flat in its sound quality but with some harshness in the high frequencies. I'll listen a bit more to Tidal, but so far I'm not impressed at all. Spotify Premium even seems to sound better than Tidal.
Some additional thoughts about Tidal after listening on higher quality equipment. I think they have applied some equalization to boost the bass and treble. In the process, I think side effects of doing this is to take out some of the presence of voices and instruments and add an artificial quality to voices and instruments.. Qobuz sounds a LOT better. Spotify Premium also sounds better. To my ears at least. (Disclaimer: Your results may vary). I'm currently listening to a track that is a MQA file on Tidal vs a CD quality file on Qobuz. The CD quality file on Qobuz sounds a LOT fuller and more natural.
Not a big fan of hip hop, but decided to listen to something that is squarely in Tidal's area of focus. I listened to 'The Box' by Roddy Ricch which is a MQA file on Tidal and CD quality on Qobuz. Same results. The Qobuz file sounds fuller and has more presence. Almost sounds like two different recordings when listening on Qobuz vs Tidal.

Round 3, Qobuz vs Amazon HD: Winner for me is Qobuz for the following reasons.Amazon: Sounds more flat. Less drive than Qobuz so that some music sounds like it is plodding along. Sound is less full. Amazon HD doesn't necessarily do anything wrong (as does Tidal), but also clearly not as good as Qobuz to my ears.
Qobuz: Much more presence than Amazon HD. More 3-dimensional. Better pace and drive. Better low-frequency response & definition. More range to conveying the emotion in music: (i.e., calmer for calmer music & more drive & pace for more upbeat music)

@mofojo local files still do sound better to me than Qobuz, but I'm happy to listen via Qobuz for new music and other music that I don't have locally.