Because of a bug in macOS, clicking on a notification banner/alert does not stop the alert sound.
To workaround this problem, you can turn on “Stop alert sounds when clicking on a notification” in Due > Preferences > Notifications.
Enabling this option allows you to stop long alert sounds, but alerts will play even when Do Not Disturb is enabled.