Change default alert sound from terminal in Mac OSX
It looks like for macOS Sierra you simply need to change the Alert Sound under the Sound System Preferences (System Preferences > Sound > Sound Effects).