I think you'll find this is down to PDAF/CDAF failing to nail focus. Switch to MF: and have the peaking option set to high for better on-screen display as to when you hit best focus.
I had the same problem with night shots using my Mavic 2 Pro...
So, recently I got a Mavic 3. This is my first Mavic. I tried using the variable aperture to take a long exposure shot for car light trails. I got a few pictures and most of them were blurry like this one!! Here are my settings: ISO - 100, f/11...