For adventurous users who cannot wait; the notification files can be found here:
https://github.com/Foundry376/Mailspring/tree/master/app/internal_packages/custom-sounds
You can fork the project and replace them and build, or do it locally by unpacking the app.asar and replace the ogg files.
(last suggestion not recommended, updates will overwrite the asar)