But telling people to just stick to established open source projects and be content with small contributions is not the solution either: first this would probably not be an interesting activity for those people and second participating in a successful OS project is by no means a protection from this kind of rejection or other kinds of grief. The "solution" here is clearly to "suck it up and move on", but I see how that can be difficult.
I'm afraid the only real advice to give here would be for developers not to get too invested in their pet projects because, like startups, most of them will never be of any interest to anyone. To all the people who are currently doing such projects, I'd say: keep doing it as long as it's fun, but not a second longer. Learn to let go.
This person clearly went on beyond that point.
The trick, as you say, is learning to let go. Accept that you'll have other ideas, and maybe one of them will gain more traction. In the course of a long career, maybe even one of those old projects will come back to life because of a shifting context or because working on other things inspired that one extra twist that makes it ten times more valuable. Setting something aside is not the same as throwing it away, and every good developer I know has dozens of ideas that they've set aside. You never know which one will be useful again some day.
That's a bit like giving tips on how to cook a healthy meal to an anorexic who tells you she's really having trouble eating enough.
Yes, we're technically correct. No, it's not really helping anyone.
Put another way, I'd say that even a spoiled rich valley girl who tries too hard to be the light of the party at too many social events can suffer from a valid burnout.
I don't have as much sympathy for her as I would for the guy that burns himself out trying to earn enough money to fund his daughter's cancer treatment, but that's another matter entirely ;)
Then start off with something people are already using and improve that rather than to re-invent the wheel in some interesting way and then to be disappointed when nobody uses your particular wheel.