Correct me if i'm wrong, but the video only applied just for the persistent universe (as Death of a Spaceman).
According to the original Death of a Spaceman, SQ42 death mechanic is different, it is exactly like in Wing Commander actually, if you die you have to do the mission level again.