I think the failure of the UN is rooted in something more fundamental than than nations failing to achieve consensus on military aims and resources.

The UN was founded, and continues to operate, on the basis of the noble fantasy that there exists a "community of nations."

Such has never existed and likely won't for the foreseeable future.