I will tell you EXACTLY why that is:
I don't know how you grew up, but when I was a kid, if I wanted something, my choices were: do chores around the house to earn it, wait for Christmas or your birthday, or do without. I always had sufficient for my needs, but I didn't necessarily always have what I wanted.
As a kid, we probably couldn't wait to become an adult with our own money to make our own choices and do whatever we wanted. (Heck, once you're 18, you can get a credit card and spend OTHER people's money and buy whatever you wanted.) But you didn't have to ask someone else for permission anymore.
Prospecting can feel like you're going back to being "dependent". Particularly if you don't feel you have a unique selling proposition, you can feel like you're a kid again... "professionally begging" LOTS of people (not just your parents)... and every 'no' feels more like a personal pain against your own internal embarrassment that 'in order to make the big money, you have to do what you feel is beneath you'. You certainly don't feel 'independent'.
This is why producers stop doing what works, why the goal is to 'stop prospecting', and why there is a "pain of rejection". It's not hearing 'no'. It's the fact that you FEEL like everyone else gets to determine whether or not you get paid today or not = feeling dependent and not able to determine your own future
... unlike at a "job" where at least you get a steadier paycheck, right?
Ever wonder why people stop prospecting? It's because they finally feel "independent" enough.
Ever wonder why people want to work referrals instead of prospecting? It's so they can feel "independent" and not feel "dependent".
It's your own self-talk and valuing independence that gets in the way... and we can't fix that until you have something new to think about.
In Stephen R. Covey's 7 Habits of Highly Effective People, we learn where you REALLY are in your effectiveness.
Look at habits 4, 5, and 6.
4 - Think Win-Win: This must be at the core of your prospecting message and intent.
5 - Seek first to understand, then to be understood: This is all about doing a good fact-find.
6 - Synergize: Make your solutions better than what they already have.
This is what we are all about as sales-people: Interdependence... not dependence.
Think about Donald Trump (as a business man, not as a politician). Could you imagine anything making him feel "dependent" when he gets on the phone to call someone? Could you imagine him making a deal where both parties couldn't both 'win' on some level? (Hey, he did write "The Art of the Deal.")
You can't fix your thoughts overnight.
But at least, when you think that you're tired of this gig, you can realize that you desire independence, and that desire is hindering you from doing what you need to be doing, because you think that prospecting is a state of 'dependence'.
This is what all those "never cold call again" and "referrals only" training books are missing! They view cold-calling as an act of desperation, when the reality is that you're offering your professional help and expertise.
You just need to get out of your own way to do it.