Tap on the Sirius weather app. You'll land on a page with the setting for your preferred location. Tap on the Settings icon on the upper right of the screen (gear icon). That will take you into settings for the app. You can turn off audio announcement of the alert from here, and also go into each of the categories of alert types and turn off the ones you don't care about.