Plus
He's "very excited" about you moving somewhere you won't be able to work? Somewhere where you will be dependent on him, because you won't be earning your own money? To add to that, somewhere where you will be cut off from everyone you know and your support system? There's no "opportunity" for you there. There's making yourself vulnerable and harming your own career prospects.
For the first quote, pay attention to all of that.
To the second, also pay attention to that. Not because he's actively, gleefully, thinking all that, but because he's not. He hasn't considered it. I don't know what your work is, but would he reduce his pension and negatively impact his carer for yours? Would he move somewhere he knows nobody to be a SAHD there? It's not for a holiday, it's not a week business trip, it's you making a life for yourself there. And supporting your kids make lives for themselves. He'll be at work with his colleagues. His life there is already made. Yours isn't. There's isn't. The idea that people just "move to lots of different countries and they have great experiences" is 10-20% of the story.
Once you become financially dependent on your spouse, it changes the dynamics in multiple ways. He's excited to go to work. He's got professional and intellectual challenges. You're now a home maker. Without family or friends. So while he's excited, you'll soon be looking at the empty days ahead less enthusiastically. Until you "fill" them..with things to fill the time, because that's what you'll need to find. Then you'll be ready to come back home and realise he likes it and wants to extend the stay, OR that you have to move back, with your job being to get the girls back in school here, then somehow find yourself work. Probably not where you left off. And then set life up again.
And honestly, that's when it all works out normally.
When it doesn't and you end up wanting to separate, we'll, welcome to the 7th circle of hell. Of course that won't happen to you, you're a solid couple. But then you've never given everything up so he can work on his career, while you, work on filling your time.
If you do go ahead with it, then at the very, very least, make sure his new salary will cover your pension contributions at the same rate as what you currently pay, plus employer contribution. If he's not willing to agree to that, there's no way I'd go.
It's amazing, honestly amazing, how many men are enthusiastic about their new overseas job, and can't wait for wife and kids to uproot their lives to support him, until it gets to the bit about making sure her personal finance situation doesn't suffer. Then she's not being reasonable, or something of that flavour. Pay attention to how he responds to protecting your personal situation, close attention, before you leave behind everything you've built up in Britain, for him.