@rollins
It looks to me that you've reached a point quite a few people reach where you reevaluate what really matters to you, and for that matter, what you'll put up with.
You've also hit the blockage to doing something about it, which is the fear .... no, not fear exactly, trepidation, of what is quite a major leap into the unknown.
I can't tell you whether it's right, and I wouldn't presume to try. I can tell you that I did something somewhat similar many years ago and while it's had an upside and downside, it turned out to be the best career move I ever made. That, of course, is no prediction that it will work for you.
It looks to me like you've really decided what you want to do, and are just trying to summon the nerve to jump. It also seems like you're unhappy, and getting unhappier, where you are.
So let me ask you this. You've got something probably like 30 years of working life left. Do you want to spend it doing something currently making you unhappy, if not making you ill? Which do you think, when you look back in 30 years, would make you regret your choice the most :-
1) Going for it, and having it not work out, or
2) Not going for it, and wondering what you missed for the rest of your life?
I suspect the answer depends on your personality type. But my view is you only live once, so use your time wisely. Or to paraphrase an old adage, better to have tried and failed than resenting never having tried. And you never know, it may be a huge success. I certainly feel my direction change was. Few things are more miserable than looking forward to 30 years more of something you dislike or hate, and then looking back on a working life you regret for missed opportunities. Obviously, it's a big decision with implications for family, but having carefully considered it, as you have, and discussed it with partner, as you did, I felt that as I only live once, best grab life by the gonads and squeeze all the experience you can out of it.