Barack Obama says the death in Yemen of the US-born key al-Qaeda leader Anwar al-Awlaki is a "major blow" to the terror organisation.