There isn't really any disadvantage for smaller sensors for macro with significant DOF, because that DOF means that you are operating within the range of practical equivalence. Many FF sensors do have more pixels though, than the typical smaller sensors used for macro (excluding things like 108MP cellphone sensors). Pixel size is only relevant in context. If smaller means more of them on-subject, then that is a plus. If one system has smaller pixels but puts less of them on-subject, then it has no advantage; just a resolution disadvantage.
That all assumes equivalent usage (same entrance pupil size and distance from subject).


