Hi, and welcome to the Apple (user-to-user) Community!
Re: "Copying Music from CD .... SuperDrive gives error "Cannot find file"
Wondering where you are transferring the music from CD's to, (eg: to Apple Music / to a Finder Folder etc.) and what method you are using:
Eg: importing to the Music app:
See how to: Import songs from CDs into Music on Mac - Apple Support
or
you can likely double-click the CD icon on the desktop to see all the files it contains, and just drag one, or more, or all of the files to a folder on the Mac.
________________________
Trouble-shooting if needed:
NB: You may need to connect the Superdrive to the Mac directly, using an adaptor, as you may not be able to transfer files if you just connect the superDrive to a hub connected to the Mac.
All the best :-)