As long as noone else is dependent upon your support, do what you love, no matter how little it pays, or how little respect it has among your peers, etc.
If you have a family or others are dependent upon you for support, I suggest you find a job you can like that maximizes your ability to meet your support obligations. Having kids, etc., may frustrate your ability to pursue your dreams as a job, but then find a way you can pursue that as a part-time endeavor.
As an example, I started as an actor, director and writer. When I decided to start having a family, I became a lawyer. I have now discovered although I love the law, the practical experience and emotional burdens of being a family lawyer are not worth the compensation, and although I loved being able to help people in difficult times, I have become increasingly "burned out," my attitude is not what it could be, and my family has suffered from my long work hours. I went back to school and I am now teaching. All along, I have continued to act, direct and write as a hobby.
From a practical standpoint, it is not always possible to have that "dream" job, but it is important to find some way to still do something with that dream. Not everyone can make a living painting, but that doesn't mean you can't be a realtor and still find time to paint.