No Christian church I know would allow it.
The person would be removed from the membership roles and not permitted to hold any kind of church office.
They would be counseled and advised to stop the sin.
By your comments, it is clear that you are painfully ignorant of how Christian churches deal with sin. I’m guessing that you are just using what you’ve heard in the Catholic echo chamber.