It's just bad... basically useless. Whenever I have received an email alert to my Blackberry, I've almost always already been at the airport. Perfect example was a flight in December. The weather was bad but I checked the flights before I left my home and it said on schedule. I show up at the airport and it says on schedule. From the time I walked from security to the gate, they changed it from 6:55pm to 8:45pm. I recevied the email on my way to the gate. It turned out that the plane we were waiting on hadn't even left Akron yet!! A Trip Alert really would have saved me there.
On another recent trip while in Miami, I actually received an alert in plenty of time... a few hours in advance saying my flight was delayed by about 2 hours. It worked out well for me since I still had work that I could do. The only problem was I received subsequent alerts moving the departure up about an hour and then a second one saying it was back to my originally scheduled time. Luckily there was another flight about 1.5 hours later and I got a seat up front and had time to eat. It worked out well, but still frustrating.