My CD-player stopped working. Does it make sense to invest in a new CD-transport?

It all depends on your equipment as to if CD or Streaming sound better. Although, in general, if you carefully choose your equipment, at any level CD and streaming will sound about the same for red book CDs. Qobuz offered half a million high resolution albums... so, those can easily sound better. So, it is simple to make streaming sound much better than CDs... more careful and / or a little bit larger investment in streaming. 

The variability in opinions comes from people comparing vastly different investment levels or house sounds or investing in synergistic or non synergistic components. 

But in general, at most levels, careful choice will get you roughly the same sound... sometimes better with streaming. And short and long term it is very worth investing a little more in streaming as you have access to nearly infinite music for almost no cost. 

“some people say that a CD still sounds better than streaming.”

And others swear streaming is just as good as CD’s. Honestly, if you enjoy spinning CDs, then get a CDT to complement your DAC and Streaming setup. 

It’s funny how often we look for reassurance, even when we already know what we like 😊

If you still have a large CD collection, go for it — why not? Get a top-loader transport with I2S, external master clock input, and a linear power supply for under $700, and start enjoying your CDs again. That transport would probably outperform digital transports costing five times as much in today’s market.

Every time you stand up to change a CD, you get a bit of exercise. Unlike streaming, where you may fall asleep during endless playback, using a CD transport keeps you more engaged. On that count alone, you’ll get your money’s worth from investing in a CD transport.

 So, why not?

You want exercise, get a turntable!

Everyone is different and what motivates each of us is a little different.  I stop listening for sound quality differences pretty quickly.  Once I satisfy myself in an A-B comparison as to which sounds best, I get bored and just stop listening for that difference.  Instead I listen to the performances.  For me part of the enjoyment is knowing the who, when, where of the performance.  Photos are good too.  Obviously, streaming does not cater to that itch the way a good vinyl album with liner notes can.  CDs are sort of in the middle with some being good, some requiring mega magnification because the print is so small, and some being as deficient as streaming.  What I am leading up to is a suggestion that you do a little soul searching.  Forget about whether a new CD transport will sound as good as, better than, or or not, compared to what you hear streaming.  The answer is all of the above.  Rather ask yourself how you listen, why you listen, are the liner notes important to you and so on.  Also, do you have music on disc that is not available otherwise that is important to you.  The answer to those kinds of questions will lead you to the correct answer for you.