The Security Council is controlled by the US and its allies (3 out of 5 permanent seats). And the Security Council does not decide on matters of public health like the WHO does. The WHO is staffed by very competent people, certainly more competent than RFK.
The UN has handled several technical matters successfully, including global vaccination programs.
And even without that, the UN isn't really set up to handle technical matters. It is a diplomatic club. The point is to give people a seat at the table without considering their competence.