I long ago got rid of all my VHS tapes, all my music cassettes, all my DVDs, 95% of my LPs, and probably 20-30% of my books, and I've scanned every last bit of paper in my possession and have shredded or recycled everything that used to be in a file cabinet (except the original of my marriage license, car title, and so on).
But CDs are the one physical medium I've held onto, and that I still actively buy and collect. The reason is that CD was the medium of my teens. I started collecting music when I was 12, buying LPs - but I really came of age musically starting when I was 15, and I got my first CD player in March 1985, for my 16th birthday. And while CDs had been around in the U.S. since 1983, it wasn't until 1985 that they became widely, dependably available at record stores, and before late '85/early '86 new albums came out on LP and cassette months before they came out on CD (at least in the U.S.) because of severely limited global pressing capacity in the early years. So because of my age and the moment CDs became truly viable as a primary collecting format in the U.S., CDs are the medium of my musical identity in a very powerful way.
I've never had a huge collection and for the past 30 years have periodically sold off a small percentage of my collection in order to keep it from growing out of control. Today I have a little over 500 titles, and the entire collection takes up about 2 square feet of floor space, so even if I decided to collect 2000 more CDs, the space occupied would be inconsequential.
I do find myself listening via my computer streamer a lot more of late - but that contains all my CDs, ripped to lossless files. And most importantly, I discovered many years ago that having CDs around, and listening to the actual discs at least part of the time, enhances my enjoyment and engagement with my music, even when I'm listening to digital files. The reason is that CDs keep me much more focused on album listening, rather than infinite shuffling of individual songs. And I discovered that listening to albums is far more fulfilling and absorbing for me than shuffling.
As for CDs' future, I agree with the folks who are saying that CDs will likely make a comeback, but that it will be much smaller than the vinyl comeback. Ironically, the strength of CD that
@restorer-john mentions - and I agree with him! - is also its biggest weakness: CD is lossless digital storage, and for that reason it's identical to what you get in a digital file or a lossless streamed file (and in practice it's functionally identical to what you get in a high-bit-rate lossy digital/streamed file). So unlike LPs, there's no unique sound and there's no fundamentally different playback approach (analogue vs digital). So there's much less fascination with CDs because they're less of an alternative to digital files/streaming than LPs are.
On the other hand, the current state of affairs means that 70-90% of CD titles ever released are available dirt-cheap. An almost uncountable number of albums is available from thrift stores for $1-$2 apiece. You can rip them to lossless files, retain a fairly bullet-proof backup in the form of the CD itself, and be financially ahead of the game compared to buying lossy files from Amazon or wherever. And as for streaming, I hate to sound like an old fogey, but I have no interest in renting my music and having to keep paying for it monthly forever or else lose it. Not to mention, I don't want the streaming company to choose which masterings I can listen to, and I don't want to log on one day and find that one of my favorite albums or artists has just disappeared and I still have to pay my monthly fee. Not for me.