[1] https://www.bhphotovideo.com/c/product/1127274-REG/nikon_264...
Its big weakness is autofocus speed (making it useless for birders, etc.)
In my experience the autofocus speed in daylight is fine and it's especially good at focusing on what you want it to focus on, so it's great for birders. The problem is noise-reduction i.e. image quality. Do a bit of pixel peeping and it begins to look like a watercolor painting.
I was lucky enough to get one the day it was released early last year. Fun toy, and great for travel/sightseeing where you often can't use your feet as a zoom, but not even close to 1" type sensor quality let alone SLR.
Saving my pennies for a Sony RX10 III 24-600mm equiv superzoom, thought it's roughly 3 times the price of the P900. Good review here: https://youtu.be/Ad1JDfmyNxI
Edit: Helps if I multiply properly. 12 seconds * 340m/s == 4080m.
Using the "Image = FL * Obj / distance" equation, we get:
.8 * 24mm = x * 70m/4080m
Where x is the focal length of the lens assuming a full frame camera.
This comes out to a x = 1119mm equivalent focal length. If you have a crop sensor, this isn't too hard to obtain. I'd be amused if the video was taken with a Canon EF 1200mm lens or something, but the probability of that is 0.
[1] https://en.wikipedia.org/wiki/Amos-6
The shot is totally within the capabilities of a 200 mm Schmidt–Cassegrain in good seeing, which is not very bulky and could sit comfortably on a medium-to-large size tripod.
The theoretical linear resolving power of that aperture at 5 km is 12 mm. But in practice it will be several times worse.
This is all napkin-based math, I've no clue what optics were used for the shot. Might have been a compact 150 mm apochromat refractor - still capable of enough theoretical resolution, and possibly a more popular option (though more expensive) in practice.