Siena’s Palio is steeped in violence, bribery and corruption. But it matters to its people more than anything, says Jasper Rees