Good point. Too much of either is dangerous! Too much confidence, and you think your shit doesn't stink. Too much humility and you think you're shit. :-)
I don't think it's confidence that makes you naive. I think that too much confidence may keep you from giving up when you should. You believe that no matter how many problems you're facing, you'll find a way to make it work. Inability to take criticism smacks more of arrogance than confidence in my mind, but maybe it's all semantics.
That being said, I agree with the parent. Humility is as important a trait as any, not matter your walk of life.