On the one hand, it cannot hurt to make people aware so they can get to cover.
On the other hand, it might desensitize people.
We had a tornado on the ground in two different areas near town a couple years ago and they didn't turn the sirens on. Was kind of a pisser.