A sound is a terrible way to get my attention. I mostly live in some kind of background noise. So, there is a strong possibility that I will miss a notification through listening to music or podcasts.
Worse, even if I do hear it, I have no clue what weird thing is trying to get my attention. Some sounds I recognize due to hearing them frequently until the product changes it. At which point, I no longer have a clue what is trying to get my attention. The only way a phone call style works for me is that it is a sustained noise that last long enough for me to check the source and see that indeed it is still active and a phone call. (This kind of thing for everything coming out of a computer would be highly annoying.)
Toaster notifications, those little windows in the corner of the screen, or even phone icons at the top of the screen are far, far, far superior. True, I tend not to immediately notice them. So, it might be minutes (an hour) before I consume them. However, that is great for my ability to focus on work or others then circle back to handle a notification.