Safari (macOS) does not play sound for web push notification
The setting in System Preferences → Notifications → Safari for ‘Play sound for notifications’ allows sounds to be played for notifications.



It's then up to the website to decide to provide a sound for Safari to play on a notification.

You can configure this for Slack in your preferences on slack.com.