First, thank you Owain Glyndwr for the confirmation of the A332 trim tank aft cg contribution.
I believe it is necessary to discuss the physiological fear response to understand the human side of what happened to AF447. The most universally recognized name for this response is the
Fight or Flight response.
Since we are not issued an FCOM for "Human Being, MK1 Mod0, we have to pick up our understanding of the special operating modes of this highly complex device through personal experience and personal curiosity. Just as our aircraft can surprise us as it switches control laws unexpectedly, your own body can surprise you with unexpected and unrequested automatic mode shifts. The Fight or Flight Response is one of those mode shifts than catch you out if you are not prepared for it.
An explanation of Fight or Flight response can be found here:
The Fight or Flight Response - NeilMD.com