In iOS 17.2 and later, Apple lets you customize the alert ... Anything else that threw up notifications used a default sound, and there was no way to change it. To change the tone - as well ...
That might seem counter-intuitive if you have an HDR screen ... surround sound, the Apple TV 4K supports it all. Go into the audio portion of your settings and change to this: Audio Format ...