Yes, I have Apple Music.
It’s interesting that the exclamation marks disappeared after I rebooted. Clicking on Library/Organize Library gave me the option to Consolidate Files, but not to Reorganize the files in Music. Doing this got the exclamation marks back.
I went to a smaller playlist, right-clicked a song, and was not given an option to “Show in Finder”. I used a utility to find that song, and found it in music/Apple Music. OK, I have a couple of hundred songs which I only have because of Apple Music, out of my 13,477 songs that my Music App shows.
I suspect that maybe 5-6 thousand of those songs are duplicates with the exclamation marks. I don’t see a way to sort my songs into exclamation mark order.
Changing thousands of songs one at a time won’t be an easy task.
I picked a song, “The 59th Street Bridge Song”. The first copy had the double cloud icon, and it pointed to where it belong in the finder. The second copy did not give me an option of finding it. So I told it to remove download. Then it had the download cloud icon. I clicked on it. I could show it in finder.
Funny thing is, the “show in finder” for these two copies of the song are confusing. The newly downloaded song is in music\music\Simon & Garfunkel\Simon & Garfunkel’s Greatest Hits\ in a directory by itself. Cloud status is “uploaded”. So I deleted that downloaded song altogether.
Trouble is, the remaining version shows that I played it once, not 77 times. It lost my meta-data.
Looking at various songs, I see cloud status of “Duplicate”, “Uploaded”, “Waiting”, “Matched”, & “Error”. Sorting by cloud status is not the same as sorting by exclamation mark.
So it’s looking that I need to go through my songs, select 5-6 thousands one-by-one that have exclamation points, and then delete those songs, starting over with meta-data?!?! This looks like a candidate for Doug’s AppleScripts, except I really, really want to keep my meta-data with the copy of the song that I keep.