CD remains a large part of my listening. I also listen to vinyl a great deal. I use streaming, usually Qobuz, to try new music out before buying the CD or LP as I can't afford to spend money on albums that I'm not going to enjoy.
I've never got into SACD. At one time I did have a Denon DCD-1500AE CD/SACD player, and I've got quite a few hybrid discs (mostly Chandos classical recordings). I just never really felt there was a justifiable difference, and the players are often quite a bit more expensive.
I think one of the biggest issues for CD now is the reliability of CD players. Whilst there is plenty of investment in DAC technology that can also serve streamers and other applications, CD transports are often an off-the-shelf afterthought. They are not built to the same standards as the older Philips ones that were used in players by a wide range of manufacturers, even those that are purpose-built for audio use.
This problem is further exacerbated by the increasing variability of CD pressings and by record companies squeezing as much onto a disc as possible to increase sales of repackaged recordings. I have some Decca box sets containing discs that exceed the 80-minute audio limit prescribed by the Red Book standards, and whilst I've never come across a player that can't read the Table of Contents, some newer players start to skip and mistrack towards the end of these discs. I broached the topic with one British manufacturer, who said their audio-specific transport may not always properly play discs outside of the Red Book standards. Strangely the Philips CDM4 transport in my 30 year old Rotel copes with them easily, as does the Sanyo mech used by Rega in the Apollo.
As I have 4,000+ CDs and wish to always be able to play them directly rather than ripping them to a server, I'm building a small collection of CD players as insurance, in case more manufacturers start to take the path Linn set years ago in ceasing support for the format.