Sounds like a feature iOS should have had ages ago.

Apple iOS 17.2 beta 4 update adds a feature that will finally allow you to change the default notification sound on your iPhone, as reported by MacRumors. The update includes a new “Default Alerts” option under Sounds and Haptics, meaning that app sounds that aren’t ringtones, text messages, voicemails, emails, calendars, reminders, or otherwise pre-assigned can be changed.

And for the silent phone fans, you can change the default haptic feedback for notifications, too.