I just saw that WeatherBug Direct BlackBerry has been updated to version 0.9.5.1, Now it has BlackBerry profile support for critical weather alerts, as well as the ability to change the alert type for over 70 different weather conditions (none, audio, visual, audio+visual) for further customization!
WeatherBug Direct For Blackberry