Despite both opposition parties on Glasgow City Council delivering positive change, the competition for the title of 'principal opposition party' lets SNP wriggle free