Music app not accessing files on local drive (most playing from Cloud only)
I have a very large music library (166 GB, 20K+ songs) on my iMac (M1 silicon, 2 TB storage, running Sonoma 14.6.1). The songs on my hard drive have been sourced over the years from early iTunes purchases, Amazon Music purchases, ripped from CDs, ripped from vinyl, and several free/legal download sources of MP3/MP4 songs. Please note that I subscribe to iTunes Match, mainly as a back-up (even though I have an external Time Machine SSD) and to access all my songs from other Apple devices.
When I was working with my Music library in iMovie, I noticed that only a very small subset of songs (a couple hundred) showed up in the Music Media pane. This caused me to do some investigating to understand why. I found out that the file location of most of my Music songs were indicated as "Cloud" even though the local library on my iMac internal drive contains the songs. The Music app seems to be accessing the matched cloud versions of almost all my songs instead of the local files. When I click on Info for most songs and look under File it says the location is Cloud.
In looking at the Cloud Status column in Music, most of the songs show up as "Matched," with some showing up as "Purchased," "Uploaded," and a very few were marked, "Removed" or "Duplicate" but they still play.
Is this jumbled library somehow due to my iTunes Match subscription? How do I get Apple Music on my iMac to reconnect to all the local files WITHOUT making duplicates? (I tried re-adding an album manually (by both clicking on the download arrow and by re-importing songs from a CD) and it just duplicated the song files.
When I go to Music settings and look at the library location it says it's under Music/Music/Media/Music and that's where all the music files ARE but the Music app is not connecting to all of them.
How do I "re-point" the Music app away from the cloud location and to the file locations on my iMac drive?
iMac 24″, macOS 14.6