John Ratcliffe comes to job with resume long on vociferous support for president, but not much in way of national security, critics say