I think that this will be in the long run a good thing for the EU. The behavior of the EU nations, particularly Sarkozy in France, suggesting that the Irish must re vote their referendum plays into all the worst stereotypes of the EU as a fundamentally anti-Democratic institution.
The fact that Polish President Lech Kaczynski is refusing to sign the treaty pretty much puts a stake in the heart of all these efforts, and makes it far more likely that other governments will take similar actions, because they now have political cover.
The point is very simple: If you want to forge a governance document, and what you come up with is so complex that literally no one in the world fully understands all of it, and your response to failed referenda to approve it is simply to restructure the agreement so that there is very little public input, you are being an idiot.
When your policy is rejected by the people that you ostensibly represent, taking the people that you ostensibly represent out of the picture is dangerously misguided.