Bob Menendez tears up over resignation: ‘My legacy is one of breaking down barriers’