Self-confidence isn't always good and self-doubt isn't always bad. The goal is self-awareness, which at its peak generates the appropriate amount of both feelings.
I meet a lot of people searching for something (career, relationship, etc). And yet, when it’s put in front of them, they won’t pursue it because they fear pain (getting hurt, failure, etc.). So they unconsciously (and expensively) trade self protection for misery.