I find it interesting the “New message sound” is Big Sur’s macOS Mail.app > Preferences and not part of System Preferences > Notifications > Mail. I discovered this because I decided to setup my new MacBook Pro as new (and not use migration assistant).