The fox sisters were household names after alleging to have experienced paranormal phenomena. But the fame wasn’t to last