No, married priests are not expected to be celibate (a term that in Catholic contexts specifically means “unmarried”) after taking their vows, they remain married.
Nor are they expected to refrain from sex within marriage, which may be what you mean.
Being a married Anglican priest is basically the only conventional way to do that. The discipline of celibacy is otherwise strictly observed.
Of course, if a married Eastern Catholic priest decided to join the Latin Church with the rest of his family, this could happen too.
But generally, a married man will want to discern the diaconate, as the priesthood will simply be out of the question, except in these exceptional circumstances.
Nor are they expected to refrain from sex within marriage, which may be what you mean.