Using Microsoft Teams on macOS, including installation, features, and compatibility
I was able to resolve this thanks to a comment on Reddit -
I went to System Settings > Notifications then turned on "Allow notifications when mirroring or sharing the display"
Removed Teams and Outlook from DND exceptions, and tried both Teams default sound and Mac sound, and all is working now. Not sure why the mirroring setting matters, but it seems to for me.