Pick for head of national intelligence hailed for her ‘experience and temperament’ after suggestions she is struggling to win support