Think of your life as a jigsaw (but less rigid and more 4D). Your interests, your family life, your work, travel, notions of retirement, the money you need to support the things you want. You can fit those pieces together in different ways.
You do need to think about how much money is required to keep the whole thing afloat and how you're going to obtain and sustain that. That path might not be linear, in the way you might at first imagine.
So you can seek work in a subject area you love, or you can work at something else you're competent at, to make money, then do the thing you love as a hobby, or a sideline. Later, once you've attained some financial stability and some marketable skills, you might be able to switch things around and work in your specialism for an organisation that does the thing you love, or get involved as a volunteer or trustee, or re-train and go in at a junior level when you can afford to do that, maybe when your DC have flown the nest.
But, do think about how much money you'll need to support the bits of your jigsaw you care about. Working in a vocational field might not achieve that for you. So maybe give it a go for five years, if acting, art etc is your passion but be prepared to re-assess and change direction. (If you have that plan from the start, you won't feel a failure when you do it). Develop other skills along the way. Or, get a marketable skill first, build up your resources, then switch later.
Also, look at the different ways people can be involved in the sorts of things you enjoy. Charities, voluntary orgs and arts organisations have a lot of volunteers and trustees. Often those trustees play a huge and important role in running the thing but they don't suffer the low, vocational wages. So be a lawyer, accountant, marketing or HR specialist, then, after a while, you'll have money and free time to spend on doing what you love and might also be able to become influential in that field, in a less obvious way.