I'm of a similar age and over the last few years I have been buying my end-stage components. I have a large collection of CDs and SACDs and I can't bear to part with them. I also stream using Qobuz but there is just something more satisfying about playing a silver disc.
I recommend something like a Marantz SA KI Ruby SACD player. I have one and I can vouch for it's quality. I have owned 3 different Marantz CD and SACD players over the last few decades and I've never had a drive fail. Several years ago I splurged and bought a PS Audio Perfect Wave Transport it had 3 drives fail in 3 years. Piece of junk. The difference is that PS Audio used a standard $15 computer CD drive which was never designed to spin discs hour after hour. Marantz builds their own transports and they are designed for playing music CDs. Marantz sill makes a SACD player so you could get a brand new one if it makes you feel more comfortable.
For less money, a used Marantz 8000 series SACD (8003, 8004, 8005), is also a good candidate. I had an 8004 before I bought the Ruby and it never had a problem. There is a bunch of these from Japan for sale on eBay (I'm not sure why).
If you go with Marantz or one of the few other companies that make their own drives (Esoteric for example) the company should have spare drives for the foreseeable future. I seriously doubt you will ever need one assuming that you are not spinning discs constantly throughout the day. If you want to do some research you can try to buy a used SACD player that incorporated one of the later Phillips drives. These are basically bullet proof but if one breaks there are replacements available.
I use my KI Ruby to play SACDs and I also have a Jay's Audio CD3 MK III transport plus a Berkeley Audio Alpha Reference II MQA DAC. I have compared the two setups for sound quality and to my ears they are nearly identical. I could easily live with the Marantz player as my only rig except that it won't play HDCDs. I have a few hundred CDs in this format and I want something that will play them to their fullest potential.