I agree that God may have future plans, but I don’t believe it should be as an overseer.
You may want to look at the Biblical qualifications for an elder in 1timothy 3
A leader must be above reproach. Certainly he can be forgiven by god, his family and the congregation but once the line has been crossed, biblically such a person is no longer qualified to lead.
Above reproach can very well make one qualified if after time he made amends and God sees fit to restore him.
I do agree however that the chances of that happening is slim to none, but with God never say never.
After all, he used a murdering racist to lead the Church into the lands of the gentiles.
Plus he forgave 11 disciples for abandoning Him in His tike of need, and one who swore He would never leave, even denied Him three times.
That is why with men it is impossible, after all we are a very unforgiving lot.
Whereas with God, all things are possible.