I think that the specific kind of "leadership" you see in those really intense guys is probably on the way out. That's not to say that the days of bully head coaches are over, but I think the tolerance for that kind of behavior is shrinking and shrinking. And really, a big part of leadership is knowing how to best motivate and orient your guys. I think coaches are becoming more aware that the players themselves expect to be treated differently, and then in turn the good ones change their leadership style accordingly--to be more supportive and positive, less in-your-face, overly-negative, threatening, etc.
I remember growing up, coaches just kind of kicked your ass. That was the expectation. Bobby Knight was a cool dude and people wanted to emulate that nasty, asshole style. Now I coach youth sports and while you still run across some jerks, most coaches are acutely aware that parents are watching, and that what parents can't see the kids will still report back.
Of course, the more competitive the leagues get, the more tolerance there is for those dickheads, because parents start to believe that their kids are really going to make it (like, pro level, not just make varsity as a Freshman, LOL). And if Mike Yells-His-Dick-Off is the best coach out there, then they want him on that team. This, however, is where the college and pro athletes come in--if they start to refuse to play for these tyrannical douchebags, then it does trickle down to the more competitive youth environments.
So, color me refreshed that all these guys have begun to speak out. Hopefully we can eliminate that kind of behavior at all levels in the next decade or so.