“That is what a cargo shift causes.”
If the weight shift is not greater than aerodynamic force - stick forward to maintain airspeed, flight normal.
If the weight shift is greater than can be aerodynamically controlled (stick forward won’t prevent continued nose rotation)- nose won’t drop when stall is reached.
Airplane reaches stall due to angle of attack, nose drops at stall and after sufficient altitude aircraft becomes controllable - normal ops. Exactly what the video shows, just without sufficient altitude to recover.
Yes, that is what weight does. Your post said aerodynamic forces could not compensate for MOMENTUM.... that is a whole different beast.