Doesn't change the outcome, or the issue of lack of go-juice, but regarding the loss of SA:
The plate posted at thread
post #37 shows the hold with northern turn at D0.6 RNG QDM 006.
However the flightradar24 path (usual caveats about this data source) in
post #62 shows the path occurring noticeably south of this point. Just visually comparing landmarks/towns on the maps, the position of the VOR shown in
the link in
post #193 and the flight path, it looks like the turn shown in the path was around 4.5nm south of the VOR.
The plate shows the glideslope intercept as being D4.5 RNG QD
R 006.
Doesn't change anything, but could this be part of the mental mix-up that led to the dive to the VOR believing it to be the threshold.
PPL (non-ifr) only so apologies if terminology not quite right, but hopefully I've communicated the possible hic-up.
So something like this: