Now in 2024 it doesn't work with Google Drive link or Dropbox link to use as MP3 audio files in CMS. So what do you do?

Design help CMS
2

Secure a host or CDN that allows you to upload assets and serve them. I find bunny.net to often be a perfect solution as a CDN that is very affordable.