There's no planet on which Cameron's visit that time was regarded by anyone on any side as anything other than a failure. Cameron was simply putting a face on it.
It has pissed off the EU (understandably), pissed off his own supporters, and pissed off his enemies.