As mentioned, CDs are pretty much dead, even file formats like MP3 are now on their deathbed since most folks have moved to streaming everything instead of owning.
I personally enjoy buying and owning physical media, it can't be deleted or removed from my own personal library unlike what does and can happen with the Internet.
Since my last two vehicles no longer have CD drives I have fully converted to ripping all of my CDs to MP3 and putting everything on USB flash drives.
Right now I have 6 GB of a 32 GB flash drive of music, that is over 2000 songs I have at my fingertips. It is like having a huge "jukebox" on a microchip.
Many of the newer car stereos, they have removed physical analog inputs but they often now have BlueTooth capability, you can find some portable CD players that have BT transmitter built in. That may also be a viable method although very clunky (many yrs ago when CDs were new to the market, I used portable CD players via analog or FM transmitter, was clunky but worked).
As far as ripping to MP3 goes, easy to do, most OS systems will have capability built in to the media player but there are lots of free software and apps which may make it easier to do.
Getting MP3s to play in album order takes a bit of learning but once you understand why it is easy to get it to work.
#1 Flash drive needs to be FAT32, not NTFS, FAT32 does have a size limitation which will be 32GB (FAT32 on larger drives can be done but requires some advanced trickery). USB flash drives larger than 32GB will come with exFAT (Extended FAT) which may or may not be compatible, I have not tried that on my car stereos as of yet. NTFS is not compatible with car stereos.
#2 You want each album ripped in it's own folder, do not copy all the files to the "root" of the drive, it will jumble up the play order.
#3 Play order will play numerical order first and alphabetical order after numerical. Files and folders named 1, 2, 3 will play before files and folders named A, B, C.
#4 Some car stereos may play folders in DATE/TIME order they were copied to the USB drive which can play havoc and make you think you have gone insane when that happens. Not all do this but be aware of this.
#5 When ripping to keep play order inline with album order you need to make sure the name has a consistent beginning to the file names. I found adding T (for track) and then 01 and increment the number takes care of 99% of the play order issues. So, the files will begin with T01, T02, T03 and so on and the title of the song after the T01, T02, T03..
Extremely important, you must include the 0.. Once you get to T10, the car stereo interprets T10 like it is the first track and all files beginning with T1 will play before all other files.
Adding the 0 forces the stereo to play 01-09 first, then T10, T11, T12 and so on..
Its a computer order thing..