I'm not sure what your trying to get at, but for the sake of argument- wouldn't it be wise to move the goalposts if it means you aren't depressed?
For me, you can view that problem two ways, "I'm going to work harder and prove my value to the company" or the move the goalposts approach, "I really didn't want that promotion anyway, I'll spend more time with my kids! No one will judge me as a failure if I do that."
Shifting priorities can be rational if you honestly realize your tastes and interests have changed over time, but most often it seems shifting priorties are just a manifestation of weakness - a decision to flee rather than fight.
Surely that might also be a realisation that the promotion you wanted takes more effort than you're willing to put in to it?
The idiocy of the comment is that "not getting that promotion" is not a failure anyway.