The SNP’s flawed version of a National Care Service was a power grab that ignored the views of local authorities, trade unions, care providers, care workers and those cared for