You have the right person – they’re a good fit culturally and have the experience to make them great at their job – but you either don’t have a seat for them or they’re in the wrong one. In this case, you’re hoping you have somewhere else they can go but if not, you have to let them go.
It doesn’t work to try to put someone into a seat they’ve never done before.