A storm is brewing within the SNP as a controversial motion ignites a fierce debate, leaving Scotland's political landscape in turmoil and communities divided.