I have the exact same issue on my 15 Pro Max on iOS 17.0.2. No matter what sound volume level the notifications and system sounds are set too, they are always sounded at maximum volume. Only when the phone is set to silent mode it stays silent.
Notifications also make maximum volume sounds even when my Apple Watch is connected, which is set to silent/haptic only.