To faint is to become unconscious. In Victorian times (1800ish) women fainted when they were overcome by emotion, or stress, or... They were a lot less hardy than these days!
So - the suggestion is that the 'you' of the song has such a strong effect on the writer, that their soul cannot withstand the emotion... I think it's a little silly, I'm afraid.