I don’t know if you can use a Marcus Lehman story as historical proof, but according to his “Meor Hagola” story in the book “Five Novelettes”, his life was endangered by his disloyal second wife. The implication is that the cherem stemmed from his personal experience.
I believe it was meant to last 1000 years, and was only meant to obligate ashkenazim.