Acknowledging weakness doesn't make a leader less effective. On the contrary, in most cases it is simply a way of expressing that he understands what everyone else has known for some time. When you acknowledge your weaknesses to the rest of your team, it is never new information.
