He will have club offers, and , if he plays well, he will have a professional career - dependent upon how well, potentially a really successful one. If he doesn't, its more likely to be that the period out of the game at a formative early career stage has set his skillset back. Of course there could be further scandals but if anything this experience -and the fact he's settled down makes this less likely than for the average player. Anyone claiming otherwise, I'm sorry, is just accidentally or wilfully ignorant to precedents (of high-profile players committing acts of racism, dubious consent, hiring underaged sex workers, assault, blackmail etc) around previous sporting scandals and has no modern historical lens: they're either naïve or disingenuous .
Barring a violent incident or the accuser deciding to retract their retraction and provide new evidence to back the original claims, the only people who will be talking about this in 2-3 years will be, honestly, those somehow trying to make reputational/status/financial coin off it in some way for themselves or their pressure group/org... or people so chimp-brained that they're not able to alter their conclusions in response to new evidence.
People are so fixated on the materials made public as somehow incontrovertible, despite the case being dismissed . Personally, I don't think the images are deep-faked, and he probably had a lot of 'making up' to do in his relationship and his attitude in general to women above and beyond the admitted infidelities... but hypothetically, as a thought experiment etc, what if they were deep-faked and that were made open. Would people still take the same line? All we know is that the evidence has been fundamentally called into question.
It speaks worse of people that they're so set on passing judgment as if the images and sounds that led to those initial conclusions hadn't bene called into question, as well as their obtuseness regarding basic processes whereby they expect this new evidence to be made open to the public, despite the fact that it might potentially impact the reputation and safety of the witness, and MG himself would be opposed to this, given the erstwhile accuser is his wife-to-be and mother of his child.. .