When letting go of an impossible dream, you're freeing yourself up for a potentially more rewarding project.
If you dreamed of playing professional football, you could become a coach (and still play for your local club at the weekends). Or you might find a completely different direction more appealing.

Find a new passion

Psychologists see goal adjustment capacity as a beneficial form of 'self-regulation' or 'self-management.' 
It contains two parts:
<ol>
<li>The ability to disengage from fruitless goals</li>
<li>The ability to know when and how to change to new, more productive goals.</li>
</ol>
Those who are flexible and adaptable are generally happier, perform better. They often get promoted. If you are thinking of giving up your dream, it suggests you have a healthy willingness to adjust and adapt.

Goal adjustment capacity

All of us have hopes and dreams for the future that become part of our identity. But then reality gets in the way. Your passion may fade, or the obstacles to realising the dream may become too big to overcome. You may have feelings of regret and failure, or fear how others will judge you.
We should take comfort in knowing that being adaptable and flexible in our ambitions is just as important as being gritty and determined.

When lifelong dreams crumble

As you let go of your dream, you may fear you're making a mistake.
<ul>
<li>There's no calculus for knowing when to give up. If pursuing your dream comes at great personal cost to your relationships and other goals in life (which is different from a 'harmonious passion'), that would suggest it was wise to give it up.</li>
<li>Success is not all or nothing. You may not have fulfilled your dream, but you likely learned much along the way, giving you a chance to redirect your energy and passions in new ways.</li>
</ul>

Come to terms with your decision

Giving up your dream will hurt, at least for a time. To drop this vision of your future-self is to drop a piece of you.
To help you move on, It helps to focus on the negative implications of your dream. If we are realistic, many of our dreams are romanticised. We may think of doctors as healing people, but their daily reality is far more mundane.

Be realistic about what you're giving up

You can relieve the sense of regret you feel about giving up a dream by doing the following exercise:
<ul>
<li>On the first day, spend some time writing about friends and peers you know have regrets about dreams they've let go.</li>
<li>On day two, write about the external factors beyond your control that led to you giving up a dream.</li>
<li>On day three, write about your new dreams, why they're exciting and enjoyable, and how they benefit others in your life or community.</li>
</ul>

Moving on from past dreams

Adaptability is as much of a virtue as grit. Overcome any feelings of loss or failure by pivoting toward a new passion

Be realistic about what you're giving up

Similar ideas to Be realistic about what you're giving up

What causes grumpiness

How to train your corporate mind

7 Things You Need To Understand About Anxiety And Depression