John Cornyn says he is looking forward to ‘working in the private sector’ once his term ends in January