McSweeney says he takes "full responsibility" for advising Keir Starmer to appoint Peter Mandelson as US ambassador.