Dear SandraJ -
Welcome!
I think artists have always run into this problem. Poets are called dreamers and painters are told to get a "real job"
. And then in the end society is stunned by Mozart and DaVinci. The artists are the ones we treasure through the centuries, not the bankers or insurance agents whose names have long since become forgotten.
So I think part of being creative is to find other creative souls to help you get through the "now" - and who know that what you are creating is something inspiring which will last.
Think of all the writers who toil away in obscurity before they get their break. I think JK Rowling was turned down 22 times before she was finally accepted by someone. She had to persevere despite the nay-sayers, and know that her creative spark was worthy.