Rear Admiral Kevin Sweeney is the third senior Pentagon official to resign in recent weeks