While the pro-democracy uprisings in the Arab world suggest there is little support for al-Qaida’s ideology but the threat has not entirely gone away, writes Brian Murphy