hey dboy...
Im in the middle of my cpl training and have pretty much the same problem as you- a lack of self confidence.
I'v been told by every instructer that i have flown with that i put way too much pressure on myself which makes things worse. The key is not to lower the standard of flying you expect from yourself but to realise that you're not supposed to be flying like an Airline pilot yet (thats why they're training us)
Just enjoy every minute you have in the air and you'll find that with less pressure comes less disappointment which will boost your confidence.
Happy skies mate.
By the way...being an Airline Pilot is just as prestigious as being a Doctor or Lawyer. Besides, the ladies dig us more anyway