Thanks for the suggestions, I'll give your solutions a try. So you don't think I'm nuts, when I sync my iPhone to the Mac, one of the error messages in the error log is: “Brand New Man” was not copied because the file type is not supported by the iPhone “iPhone 12”.
To give you some more insight, following are two records from the exported Music XML file. They refer to songs from the same artist/album (the second one is referenced in the error log above). Info in the first record is all correct whereas in the second record, all the info is correct except the file location points to an Italian language help file for an old Eye One Match color calibrator. Hence, the error that the file type is not supported. I think that somewhere along the line, over years of OS upgrades and iTunes upgrades and migration to Music, some links must have somehow gotten scrambled. Oh, one more tidbit, I have not thoroughly analyzed this so it's not 100% certain, but so far it looks like the scrambled file locations are from CDs I ripped a long time ago.
<dict>
<key>Track ID</key><integer>2845</integer>
<key>Name</key><string>Cheating on the Blues</string>
<key>Artist</key><string>Brooks & Dunn</string>
<key>Album Artist</key><string>Brooks & Dunn</string>
<key>Composer</key><string>Chick Rains/Don Cook/Kix Brooks</string>
<key>Album</key><string>Brand New Man</string>
<key>Genre</key><string>Country</string>
<key>Kind</key><string>MPEG audio file</string>
<key>Size</key><integer>2768672</integer>
<key>Total Time</key><integer>172120</integer>
<key>Track Number</key><integer>4</integer>
<key>Year</key><integer>1991</integer>
<key>Date Modified</key><date>2010-11-18T22:30:13Z</date>
<key>Date Added</key><date>2016-04-10T16:41:51Z</date>
<key>Bit Rate</key><integer>128</integer>
<key>Sample Rate</key><integer>44100</integer>
<key>Play Count</key><integer>4</integer>
<key>Play Date</key><integer>3743926107</integer>
<key>Play Date UTC</key><date>2022-08-21T18:28:27Z</date>
<key>Normalization</key><integer>2336</integer>
<key>Persistent ID</key><string>625FDF04D24DD346</string>
<key>Track Type</key><string>File</string>
<key>Location</key><string>file:///Volumes/Personal/Dropbox%20(Personal)/ITunes%20Library/Music/Brooks%20&%20Dunn/Brand%20New%20Man/04%20Cheating%20on%20the%20Blues.mp3</string>
<key>File Folder Count</key><integer>5</integer>
<key>Library Folder Count</key><integer>1</integer>
</dict>
<key>2847</key>
<dict>
<key>Track ID</key><integer>2847</integer>
<key>Name</key><string>Neon Moon</string>
<key>Artist</key><string>Brooks & Dunn</string>
<key>Album Artist</key><string>Brooks & Dunn</string>
<key>Composer</key><string>Ronnie Dunn</string>
<key>Album</key><string>Brand New Man</string>
<key>Genre</key><string>Country</string>
<key>Kind</key><string>MPEG audio file</string>
<key>Size</key><integer>292</integer>
<key>Total Time</key><integer>261694</integer>
<key>Track Number</key><integer>5</integer>
<key>Year</key><integer>1991</integer>
<key>Date Modified</key><date>2009-10-15T23:01:18Z</date>
<key>Date Added</key><date>2016-04-10T16:41:51Z</date>
<key>Bit Rate</key><integer>128</integer>
<key>Sample Rate</key><integer>44100</integer>
<key>Persistent ID</key><string>20744769E88B6070</string>
<key>Track Type</key><string>File</string>
<key>File Type</key><integer>1413830740</integer>
<key>Location</key><string>file:///Applications/Eye-One%20Match%203/Eye-One%20Match/Contents/Resources/Italian.lproj/Help/i1Display/Start/Step5.txt</string>
<key>File Folder Count</key><integer>-1</integer>
<key>Library Folder Count</key><integer>-1</integer>
</dict>