I think mentioned elsewhere here, https://github.com/MiczFlor/RPi-Jukebox-RFID is great for this. I did something similar with an opp shop Fisher Price[0] record player, with the RFID reader under the turntable and each 'card' is a laminated record cover with the rfid stuck on it. Lots of good photos of different implementations in their issue threads.

We also use it for kids podcasts (autodownloads them weekly). I added a TTS script that generates a friendly audio message from a text file that can be triggered to play from an alarm or for a specific record. This announces the weather with a Dad joke at the end. I tried to automate the last one with various sources (db, LLM, etc - but felt too cold, so I just dictate it to the server from the phone) and usually add a customised message about our family calendar (wear a jacket for rain. cousins are coming today).

[0] https://www.amazon.com.au/Fisher-Price-Classics-Record-Playe...