Republican Sen. Tillis calls his vote for Hegseth the ‘biggest regret of my career’ in a new book