Money is liquid value. It is also value neutral. Not wanting money is generally nonsensical as it can be put toward any purpose, especially non-materialistic purposes. If you mean to make some statement about the futility of purpose, then that is really outside the bounds of a discussion on following your passions (and being able to live at the same time). I mean, if their work is so important to someone that they do not want to exchange it for money, then that is a different topic. That does not mean what they do is not worth money.
If people are not willing to compensate you, how valuable is what you do? If you write a brilliant novel, wouldn't people be willing to reward you? I would. Does that mean you should seek money or prostitute yourself? No, but don't complain about being penniless and following dreams. The two are not mutually exclusive, we only make it so.
Can something be valuable only to one person and to no one else? Maybe, but I wouldn't consider this art as important as something that has the ability to resonate and impact other people. Look at the art of schizophrenics. It is normally so individualized and without unity that it just does not have the power to resonate with the viewer except on the level of oddball curiosity. True art impacts and connects. True art reflects back the universality of life and this world.