This is a disaster. Six months and the alarm tone is still missing from notifications. I have no clue why the iOS team would arbitrarily decide to take the only useful tone and replace it with more "oh so gentle" alternatives. (Is it yet another instance of preferring aesthetics to functionality?)
Just in case Apple doesn't know: When you are deeply focused, it is very easy to filter out every notification tone on iOS except "Alarm." If Alarm was the only option available I would go crazy, but there are some cases where it is essential for work and productivity. In my case, there are some work emails from some clients that I cannot miss, and the gentle sound of synth raindrops aren't enough to ensure that never happens. I used to set those clients to VIP and the notification tone to "Alarm" to make sure it never did. Now I've got nothing and have to look for alternatives to iOS mail to make sure my workflow actually works. Seriously, what is going on in that head of yours Apple?