Catalyst apps for me have only started using the custom notification sounds after restarting my computer once after them being installed - a wonky workaround, but it may work? Doesn't seem particularly great for production builds though.