I've had similar experiences to what the quote describes. I'm in a bit of a rush and have not actually read the link, but here's my thoughts:
Is the epiphany purely in a way of thinking about things, or does it lead to some material change? In other words, is it actionable? For example, if I come up with new way to frame work for extra motivation, I don't put much stock in it, because I know that my mental state is highly variable and it sometimes just won't work. I write it down, and think about it, and see how long it lasts, but I don't expect it to have a huge impact. I'll put higher stock in things that create some system or make some physical change in the world, like finding out about GTD, nootropics, etc. -- there is a much wider set of mental states in which they will likely work.
LW doesn't seem to have a discussion of the article Epiphany Addiction, by Chris at succeedsocially. First paragraph:
I like that article because it describes a dangerous failure mode of smart people. One example was the self-help blog of Phillip Eby (pjeby), where each new post seemed to bring new amazing insights, and after a while you became jaded. An even better, though controversial, example could be Eliezer's Sequences, if you view them as a series of epiphanies about AI research that didn't lead to much tangible progress. (Please don't make that statement the sole focus of discussion!)
The underlying problem seems to be that people get a rush of power from neat-sounding realizations, and mistake that feeling for actual power. I don't know any good remedy for that, but being aware of the problem could help.