Wow! This thread is very thought provoking. I appreciate these types of threads here, and this subject matter in general.
Everyone has posted some very valid points. I could comment on most of them, but for the sake of time and space, I'll just add a few of my own thoughts.
Firstly, I must say that comparing the behavior of a child, to that of a muture minded adult can be somewhat misleading. Our receptors for pleasure are clearly different. Also our reasons for performing certain tasks, fun or not, are also much different. I'm not completely disregarding the theory, but as with all things, the context of the situation must be considered.
As far as the three conflicts go, there is one common denominator, the "man". It always returns to the expectation of the person for themselves. In this instance, they know how well they can shoot, and they expect a certain level of accuracy and consistency. When they don't achieve what they know they are capable of, within reason, they become disappointed in themselves, and can start a downward spiral, where they think they are doing something wrong, and need to try and change or try something different. When in reality, they need to change their frame of mind.
Confidence is the key! Everyone makes mistakes, and makes a bad shot! Having confidence in your equipment and your ability is paramount in recovering from a less than ideal shot.
I mentioned mind set earlier. This is also a very important aspect in most endeavors. You must live and breathe this very moment in your life! This shot is the only shot! There were no shots, good or bad, no scores before this one. Everything must be new and fresh. Spontaneous! Like picking out a stump that you've never seen before. You cannot live in the past, or worry about the future. If you do, you'll miss this moment right here and now and miss the target (your concentration will not be 100% focused)!
Stage fright, or the fear of performing in front of people, is a whole other can of worms. It's silly in reality, to worry about what others might think about you. How in any way does that negatively affect you? Regardless, it is something that many people deal with.
Sorry if I got a little off topic and long winded. Great thread!