Should I still buy a CD player? Suggest one?

The Pro-Ject Pre Box S2 Digital is a great value at $400. The DAC functionality is very good sounding, it can function as a preamp and has a good headphone output. It works at almost any available resolution and got an EISA Best Product Award. I use one in my office system and can recommend it highly.

https://darko.audio/2018/03/pro-jects-densely-packed-s2-digital/

https://www.theabsolutesound.com/articles/pro-ject-pre-box-s2-digital-dacpreamplifier/?page=3

https://www.project-audio.com/en/product/pre-box-s2-digital/

What year is this? We have lived in California and Arizona, in close proximity to Best Buy, and I was told years ago that BB was discontinuing CDs. It’s a matter of saturation. Are there really any CDs that you want that you haven’t bought already? Of course not! Unfortunately, the same may happen to vinyl in Barnes and Noble. I was in last week and they are selling tons (yes, tons) of popular titles of vinyl for "50% OFF". Check it out.

OP

Did your  CDs survive the fire?  Do you have a large collection?  Are they not backed up to a HD?  If the answer is yes to all 3 questions, then it seems like you will want a CD player.  Unless, of course you are ready to ditch the CDs and go with a streaming service.
  If you are undecided about replacing CDs with streaming, I would suggest buying a decent inexpensive streamer such as the Bluesound Node2i before buying a CDP.  Try one or more streaming services—they all have free trial periods, and the Node2i works with with all of them.  It has a decent DAC included, probably about the same level of quality as your old CDP.
  If you decide that streaming works for you, great.  If you miss CDs, then buy a CDP, and use the streamer for the  Internet Radio and perhaps  Bluetooth functionality .
CD players will continue to be sold.  To many people have large collections that they want to play and CDs will still be sold on line.
Personally I would put most of the money in a good DAC that can be used with all digital sources

I sell and service the CEC brand of CD players and transports. There are links to reviews on the web pages.  http://audio-union.com/audio-union/cec/

The Bryson BDA-3.14 is a combination of a superb DAC and streaming capability. Pair it with a Cambridge transport and you'll have an excellent CD / Streaming setup.
Just a thought.