You can embed audio files into a Google Site, but it's not the way you might think.... You can't just select from Google Drive you have to embed a link... here's how:
2. Double click on an empty space, and choose Embed
3. Paste the shareable link where it says By URL
4. Choose Insert