A woman opened fire with a long gun inside the celebrity pastor's megachurch in Houston on Sunday afternoon before being shot and killed by off-duty police officers, authorities said.