Research shows top performers don't always become great managers. Here's why leadership requires different skills than technical expertise and individual success.