Only if they are defrocked by Rome - not if they renounce their vows themselves. In that case, they may be allowed to resume their priestly role, at the discretion of the Bishop.
My family's parish in New York was the domain of just such a 'father' - in both senses of the word (he was a widower).
Good point. Thank you for the clarification :-)