A Foreign Affairs Committee investigation found it it was 'difficult to understand' how the disgraced peer was handed the plum Washington role, citing concerns about national security