Personally, IMHO, yes.
For sure, you do have a chance with Aer Arran and so on, maybe even more should you be so lucky.
However, you MUST weigh up the "cons". The "pros" are obvious.
The cost. Will you earn your costs back? You're 40ish. Yes, that gives you 20 or so years to earn the money back. However, when you're in your 40s you should be earning maybe 30-40K already. You may only be earning 18-25K for 5+ years. If you're lucky...
Factor in the costs of training versus family holidays, presents and the like.
Now, the view from the LHS of a jet is pretty good. Amazing actually. However, starting at 40 odd with a young family etc just may be too expensive. Your family is really the most precious thing you have.
You must look at it with an objective eye.
If you can weigh it all up honestly and believe it's worth it, then go for it.
Look up GAPAN and do their tests.
Good luck.