I wouldn't expect to see the same quality. Sony in the RX100 series can produce useable images up to ISO 800, I would never use the M2 Pro camera past ISO 100 unless really necessary. Personally even though the raw's exif show a "Hasselblad" camera, I doubt Hasselblad had anything to do with it, besides letting their owners DJI use the name on the camera".
A few considerations:
1. Stay at F 2.8 to max F4.
2. Bracket 5 shots. The sensor/camera can't take really any push in post without showing noise in shadows even
at Iso 100.
3. Consider using a different raw converter, ACR/LR IMO has a poor conversion, shows more noise than raw therapy
or Capture One. NOTE LR is forcing you to use the manufacturers lens profile info, C1 allows you to turn it off.
You may find that C1 generic lens profile will give you more details, albeit with considerably more distortion.
Distortion can be easily fixed, loss of detail harder
4. I turn off AFC always, use AF to hit subject target, then move to MF. I would not try using MF by itself to focus
unless you are close to subject 20 feet or less. The DJI go app doesn't allow for 100% view for Live View and
without being able to zoom to 100%, dialing in critical MF is hard to do, even with peaking.
5. I tend to use AF on the center of the subject, as focusing on on side of your subject can create one side
over the image being a bit soft.
6. More you aim up or down off center, the more distortion you will get and the the distortion is considerable.
ACR/LR correct for this using camera profile, with loss of edge details. I prefer a manual correction using
Capture One. Capture One IMO also has a clear overall raw conversion.
7. Keep your shutter speeds in the 1/60 to 1/2000 range if possible. Sure the camera will go slower, but there is no
IS or VR on the Drone and it's moving all the time slightly albeit this is masked by the gimbal, but just that slight
gimbal movement could be enough to create a blur.
As you can see from your Sony RX100 camera, the 1" sensor in actually has quite a good range, or it's easy to compare on sites like dpreview. The same sensor in the DJI family of Drones,
P4 Pro,
P4 Pro Vr 2 and M2 Pro has a much lower DR range, again ISO push is pretty worthless past 200.
In bright daylight, camera does great, but early am/late pm or cloudy days you really need to consider bracketing your raws, and work on them in post. Can be a lot of work, but results can be positive.
Paul C