Simon Tisdall: Oil has always given the Gulf monarchy huge power. But the US may be less dependent in future – and the world is fast losing patience with Saudi Arabia’s stance on human rights and extremism. Will King Abdullah’s death change anything?