I suppose I must have around 3000 CDs now. Once the number reached 100 (probably around the year 1990 or so), I quit counting. I just did a quick count of the CDs shelved by my desk, and that was over 500, so looking at the other shelves, I'd say 3000 or more total. I'd hate to be a young person with my tastes in music, as it would be impossible to amass this collection, as so many of these CDs are out of print. Nearly all of my CDs are classical, with a fair amount of opera music (I have fewer than 100 pop/rock/jazz CDs). So I represent a tiny percentage of a tiny percentage of the population, listening to unpopular music and primarily using physical media.
Something like Spotify is handy for music discovery and casual listening, or for somewhere like work or a vacation where it's not possible to have my physical collection at my fingertips. But I'd hate to have to rely on music labels, streaming services, ISPs, etc. to maintain availability. Right now, I'm okay as long as there is power and this house doesn't burn to the ground, taking my collection with it. Even if the rest of the world continues to move away from physical media, the persistence of the LP reassures me that there will be some form of disc player that will have backwards-compatibility with the CD, at least for the rest of my lifetime.
The compact disc ushered in musical freedom for me. Prior to that, music lovers were at the whim of the labels and the crummy brick and mortar "record stores" as far as availability, and the purchase options of LP and cassette both deteriorated with each use, with no assurance that a copy could be replaced when it became unplayable. The advent of the CD also provided incentive for the record companies to open the vaults. Now it appears that in some ways things may go back to the old ways, except that instead of unstable and compromised physical media, it will be compromised digital files, and the vagaries of the cloud rather than brick and mortar.