The kitschy, gay-friendly spectacle gave liberal Israelis a tantalizing glimpse of the country they once cherished – but it could turn out to be their swan song