Why popular sovereignty did not work in Kansas?

Because it was the only state voting at that time, so it attracted every terrorist from both sides to intimidate voters. The resulting violence was called 'Bleeding Kansas'.