...no it's not?
Much of traditional psychoanalysis has been superseded by modern psychotherapy. And I'm not even familiar with that idea being part of psychoanalysis in the first place. (And there are many schools of psychoanalysis that disagree with each other too.)
Quite frankly, it's not a great insight. It's perfectly fine to want something and then get it. Don't worry, you'll want something else afterwards. The idea that you should set your sights on an impossible goal doesn't hold up to the slightest logical scrutiny here. And a lot of people get disillusioned or burned out from trying to achieve impossible things and failing.
Modern psychotherapy is actually about aiming for achievable, realistic goals in your life. It's much more in line with the serenity prayer, in terms of aiming for realism:
God, grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to know the difference.