Even if you keep your phone on 'Do Not Disturb' mode, it's essential that weather alerts override the silence.

Type Do Not Disturb or DND in the search bar. In some phones, it is also available in the Quick Settings Panel. Turn on DND mode and you will get the option to schedule and customize it.