The core issue with the UN is that it’s an artifact of the Kisinger-esque “great powers” geopolitical mentality - specifically, that a handful of fuck-off powerful formerly (sometimes barely) colonial/imperialist nations “know best”. And sure - sometimes that collection of countries does push concepts that are genuinely constructive and helpful. But very often, it also devolves into simply preserving the vestiges of imperial-powers-of-old.

Until and unless the UN is able to reform itself in a way that the General Assembly has some sort of mechanism to actually override the UNSC (or, more specifically, whatever country on the UNSC decides to cast a veto - particularly permanent members), the UN will remain essentially impotent.

I do think it would be a fantastic idea if UNSC vetos required another SC member to second said veto for it to actually go into effect, and even then allowing some sort of override mechanism in the UNGA provided there’s an overwhelming majority… but I don’t see that happening, because the parties that would have to sign off on that sort of procedural amendment are the same parties that would lose unilateral power under that arrangement, and that’s simply not going to happen.