I don’t think that great work and financial success are necessarily related; in fact, in many historical cases they were not. For me personally, I always have special and long-term projects on the side (that may or may not lead to “great work”), while doing more boring work in my bread-and-butter job. I guess I need some sort of independence from financial or social pressure when I want to do what I am passionate about, even if it means that I am not able to go “all in”. Otherwise it would only stress me out and in the worst case, I would lose interest or drift away from my original intentions to satisfy a customer or whoever might give me money.
So many very valuable or important things are just not profitable, but that doesn’t mean they should not be pursued.