This is perhaps the misconception about team leadership that is the most damaging. It is damaging because so many people believe it and it discourages people from taking on team leadership roles.
Any type of personality can be an effective team leader. You do not have to by funny or confident speaking in front of people. You do not have to be tall and handsome or beautiful.
Effective team leadership is not about those types of things. Effective team leadership is founded on your honest efforts to help those around you be successful. You can do this no matter what type of person you are.
There is a common phrase about team leadership that I think does not get the respect it deserves; “He/She leads by example." You absolutely do not have to be charismatic to lead by example, yet it is one of the most powerful ways to lead.