As Iran and US agree fragile ceasefire, Israel’s conflict has turned out to be a bust and, say opponents, ‘a political disaster’