Auburn superintendent resigns after video goes online