Appointing Lord Mandelson as the UK's ambassador to the US was "worth the risk", a minister has told Sky News.