The serial killer’s wife and daughter were in court as he confessed to killing eight women