I await the accident report with interest
There's not many things that would cause an aircraft that size to enter a nose-dive. Deliberate pilot action is one, and a sudden shift in cargo is another. It can also be the eventual result of an aerodynamic stall, which in turn can (and has been) caused by making a mistake when programming the autopilot with neither pilot monitoring the instruments as they should. Nevertheless, when the stall-warning and stick-shaker activates almost all pilots would react in a way that prevents the nose dropping as much as it apparently did here.
Yes, the cargo is on pallets or in bins, but they are on tracks in the fuselage. There are stops on the tracks that must be raised in front and behind each bin or pallet to prevent it sliding. If a heavy bin/pallet has a space on one or both sides (very common when a small but very heavy pallet is close to the maximum weight allowed in its station), and the loader has forgotten to engage one or more stops, it can and has caused a lot of damage. As an example - the locks have been engaged on the tail end of the pallet, but not the nose end, and the pallet is situated close to the tail end of its load station (compartment). All is fine during takeoff and cruise, and also cruise-descent which is a very shallow dive. But as the aircraft is pitched further down for a faster descent to land, the friction between the pallet and rails is finally overcome and it slides forward building up speed until it crashes into the pallet in front at the next station. The shock overloads the stops which break and now there are two pallets rushing forwards. Etc. Besides mechanical damage that may be caused to the aircraft frame, the C of G moves suddenly much further forward than the amount that can be compensated by the elevator, and the aircraft noses over and dives into the ground PDQ.
Not saying that's what happened, but it's a plausible scenario that requires only one point of failure (a forgotten bin-stop) that would be completely symptom-less before the sudden catastrophic event. Bins/pallets can each be loaded with several tons of cargo.
Another scenario we have unfortunately seen before - a suicidal pilot.
The flight recorders will soon make clear what happened, I'm sure.