Once a creature’s ward ability has triggered, causing that creature to lose ward by removing Cathedral Acolyte won’t affect the ability. The appropriate player will still have to pay or see their spell or ability countered.