“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.