U.S. bishop-elect resigns over abuse allegation weeks before taking office