I suspect you’re encountering the issue discussed at SONOS not playing specific files
Do you have “Perform extensive media analysis during maintenance” (Settings > Scheduled Tasks) enabled for your server?
See SONOS not playing specific files - #40 by Volts for forcing deep analysis from the CLI.
I’m using the following query to identify tracks which haven’t been received deep analysis and pipe them to CLI, where 3 is the id of my music library.
SELECT metadata_item_id FROM media_items WHERE library_section_id = 3 AND bitrate IS NULL;