[eridius]

If you right-click any local song¹ there's an option in the context menu to show the song in the Finder.

¹Music available in iCloud Music Library but not explicitly downloaded locally doesn't offer this of course.