The rule itself is pretty clear that the firing unit is the one that takes the wound. I took a look through the rulebook, designers commentary, stepping into the new edition, rulebook FAQ, and Admech FAQ (I hate rules bloat) and there's nothing that I can see that requires a model to be on the table to be killed, so best I can see, the embarked unit takes the mortal wound.