The United Nations chief sharply criticized the powerful Security Council for a failure of leadership to end wars in Gaza, Ukraine, Sudan and beyond