Apple has introduced the ability to change your default alert sound with the release of iOS 17.2 beta 4.
If the feature makes it into the public release, users will be able to navigate to Settings > Sounds & Haptics > Default Alerts to customize the alert sound used systemwide.
With the release of iOS 17, Apple introduced a slew of new ringtone and alert sounds. The current system default alert is "Rebound".