Just one point -
In the 2 seconds prior to impact the nose is raised by 42degrees, I don’t know if it is fair to say “almost NO pitch rate”? Are you saying that in the last 0.1 seconds he stopped the pitch rate? And in any case the Inflow from his path of motion compared to his disk attitude is the thing. It has little (nothing) to do with absolute attitude (which is flat)
it is his inherent training that if he is going to hit the ground/water hard he needs to do it in a level attitude - that and the fact that continuing to pitch nose up would put the TR into the water first. he realised he was going to crash and tried to make it survivable.
I’m guessing 1.7g is all you can pull in that helicopter at that (probably drooped) RPM and speed. You can see the coning angle is as high as you’ll get it, can’t do more.
you have said that you can use coning angle as an indicator of G load and I know an apache can pull more than 1.7 G so why is the coning angle 'as high as you can get'??