First I like to refer to a closed thread: No notification sounds (Mac)
I’m wondering why the thread was closed with no change to the described behavior.
The issue is still present: Brave and other Chromium-based Browsers won’t play any sounds when notifying. The only one that is able to do so is Firefox.