I think stand alone CD Players are mostly dead, but I don't think the Redbook CD format is dead. I differentiate CD players from universal disc players that player SACD, CD, DVD, and Blu Ray.
My old standby player was a Rotel RCD-950. Having an IT background, I always have more computers laying around than I need. Back in 2009 I decided to rip a bunch of music using EAC into wav, and compare the sound quality to my CD Player. My PC was connected to my Rotel RSX-1056 receiver with an optical digital cable, and my CD was connected with the usual analog RCA cables.
Had the same song playing on both systems and synced up. I could barely tell any difference between the two when switching between sources. I then brought my wife in and had her listen as I switched back in forth. On a few different songs she thought the PC source sounded better. At that point I ripped all my Cd's to files and have never looked back.
To this day I still buy some CD's. They are simply used to rip into FLAC, and then are put in storage out of sight. Personally, I can never see going back to having racks of CD's in the living room, plucking a CD from the shelf, putting the disc in the player, and pressing play. I play vinyl when I want that level of interaction. I have purchased a few high def music files if I'm sure they were not upsampled from redbook, but I still buy lots of CD's.