Does it? Lack of confidence can hurt you. I see that. But so does over-confidence, as shown by the study linked above. As a shooter, the best thing is to have a steady mind and short memory.