Play music or sound on Bluetooth headphones when alarm goes off

I am trying to play music (or any sound) on my Bluetooth headphones when an alarm goes off. Weirdly, this is not supported by the alarm app according to Apple support.

I spent hours on the phone with support about this just for their supervisor to eventually tell me that this is a "known issue" and might be fixed at some point in the future. Sadly, they could not tell me when and it still does not work in iOS 18.

The closest I have gotten is to set up an automation that opens YouTube Music, however that only works while the phone is unlocked

Is there another trick to get this working reliably? I frequently sleep through alarms because of this limitation.