I would have concerns about my son playing football, but I don't think this event really changes that one way or another, although it is certainly something that will live with all of us forever.
This is a freak/fluke accident than can happen in basically any sport. Lacrosse, Hockey, Baseball, you could even have a basketball player lower his shoulder and cause this. I don't know that this is a football-specific injury.