Like has been said, ignore the fact its a drone and instead compare it to a dslr/mirrorless system.
Medium frame - massive sensor, huge dynamic range best 'picture' most expensive (and things like auto focus are slower due to pixel density etc) Red's / cinema cams tend to be this sort of sensor, and they are almost all manual focus. 50-100+mp is the typical, and 20k+usd price for body only.
Full frame (I know most think should be bigger than medium, but hey) - kind of the 'sweet' spot for price/feature/quality. The eos1d / 5d and high end Sony/etc are these, these are the cameras that a 22' lense IS actually 22 on. Considered 'pro'. Have great dynamic range, and advanced tracking auto focus systems.
APS-H - Kinda less used now, but used to be the pro level, nearly full frame but not quite. 1.3 crop to full frame
APS-C - Most Canon/Sony non-pro cameras, less dynamic range and sensor not as big, but great price/performance level. 1.6 crop
Micro 4/3 - another popular format like APS-C, smaller than that, and less dynamic range, but still good. Lots of bridge cameras use it.
CX/1inch - this is mainly used by Nikon and Sony, and hense the use on the drone and other 'portable' cameras. Less dynamic range, but still considered a real 'photographic' sensor as such.
After that CCD's are considered as 'lenseless' as they are mainly used for phones etc where interchangeable lenses are not a thing.
This is why the 1inch sensor of the
M2P/
P4pro is so impressive, they are considered large sensors with real capture capability. Now I think its going to be a good while till we get APS-C let alone full frame sensors on 'all in one' craft like the DJI consumer/prosumer drones, but the 1inch sensor is a huge leap up in capturing light over the tiny sensors of old.
Remember most photographers would actually rather shoot a low (15-20)mp full frame sensor over a huge(40+) 1inch or less sensor, purely as each pixel is much larger, larger pixel = more light = more range and better shooting in challenging conditions.
So (very) long post short, unless you NEED the zooming for something (and it has its place) your best of for photos (and mostly video as well) to have the 'better' sensor. The
M2P does have a 'zoom' as such as well, the HD / Full sensor shooting modes do zoom (well it crops to native pixels) and you get that, it's not a real focal zoom, but there anyway.
Hope that helps...