Modesto priest says those who voted for pro-abortion politicians should consider confession, but his bishop publicly undercuts him