My understanding is that this alert is mandatory, and will sound no matter what unless the phone is fully off. You can turn off things like Amber and Weather alerts, but my understanding is that this one (by design) cannot be disabled.