Brazilian bishop resigns after inappropriate video goes viral