Did the veto only exist in the first place because it was necessary to sell the concept of the EU? Telling governments “don’t worry, you’ll be able to veto anything” sounds like an argument you’d need in order to get skeptical countries to join when the EU was new and untested.
In practice, the veto seems like a terrible idea. Any stubborn, selfish head of state can blackmail the entire EU by threatening to veto an important measure.
Now, the EU has proven itself, plus, member states have seen the perils and costs of leaving. There’s much less need to accommodate those who refuse to act in good faith. Getting rid of the veto is an excellent idea.