Former prime minister John Howard says the war in Afghanistan had "not been a failure" because it stopped further 9/11-style attacks on the West being launched.