The significance of Victor fainting at the sight of the murdered Elizabeth is that it implies that has he been feminized by what has happened to him.
Victor Frankenstein the hard logically-minded scientist has, in a way, usurp the feminine role of mother. He has given birth to a monster, therefore, he has learnt of the sensitivity of the mother role.