Saudi Arabian détente with its regional rival has unravelled as US-Israeli war triggers furious Iranian retaliation