Currently custom sounds can only be set for Nagios' default error states (WARNING, CRITICAL, DOWN).
Setting sounds for error states from other monitoring solutions (e.g. AVERAGE, HIGH, DISASTER in Zabbix) are therefore currently not available.
This is in contrast to notifications and color settings which indeed do support these states.