IMO, CD with mp3 is the sweetspot for car use. Regular CD is too short and it's awkward and/or dangerous to choose and change the next disc while driving. Some flash based storage with ton of music on the other hand gives too much choice and it's hard to pick next album while driving. Spotify can be ok but if algorithm takes you to a strange place it's also not easy to switch something else with hands on the wheel. And there's a question of cell coverage, or roaming costs if you drive across countries. I know you can download on Spotify, I'm using it as an example of "play anything" streaming vs preloaded collection.
CD with mp3 gives something like 10 hours of music which is perfect for longer trips. You spend one time to make few compilations, you pick a disc depending on a mood and you're covered for the whole trip, you don't think about poor reception.
Sure, you can also make playlists with Spotify/flash, but you're not "forced" by medium so we mostly don't do it. And if there's a passenger willing to be a dj then it's a different thing.