He won't go to another club, I don't think. He's staying within the City group for a year and otherwise taking some time off. Pretty much every day for the next 2-3 years he's gonna wake up next his wife (providing they patch things up), he's gonna be making lasting memories with his dear old dad, he'll be watching his kids become proper adults, and he'll be golfing, reading, and drinking wine by the sea for the foreseeable future. And he'll be relieved to do so.
His dad will pass away (sadly but likely in the next 5-6 years), his relationship with his wife will hopefully settle down (again if all goes well during their reunion over the next few months), and his kids will be all over the world by then. By 2032/33 he might start getting the football bug back, but not until then imo. He's lost a lot of time to football and he's going to work hard at claiming as much of it back as he can. Maybe then he'll think about international jobs.
If he regrets leaving City that badly in the future, he'll know he can come back. There's no chance we tell him no. With that in mind, I think he knows that he can spend the next 5-10 years back in Barcelona or on holiday, back in the year-round sunshine, gathering with old friends, watching football and relaxing by the sea, and maybe managing England or Italy or wherever he fancies. He knows the door is always open so he can tune out completely for a while.
If Pep wakes up one morning in the next 2-3 years and realises he regrets leaving City, he won't phone Khaldoon in a panic like "Shit shit shit I'm sorry can I come back", thinking that there's a time limit. He'll alert Khaldoon for sure, but we'll just say "Look Pep, we'll always say yes to having you back, but there's no rush, so have some time out with your family and in 4-5 years we'll be waiting for you, don't worry". But I doubt even that will happen, to be honest.