Not necessarily. It can be I guess, but my last position the lead dev was very likable but totally incompetent. He wasn't a motivator or anything either. He actually hurt morale because of his inconpetence. He just had a likable personality. The project itself was millions of dollars and several years behind. But the business people with the purse strings liked the guy and he knew enough to bullshit them.

I've seen this pattern repeated alot throughout my many years. Most jobs aren't really that hard so the real way to keep the job and thrive is to just be likable.