The majority of people in Scotland do support the union - or they did back in 2014 - but the organisations representing them are a shambles. No money, no coordination, no single coherent message and no strategy. Without someone bringing them all together to sing of the the same hymn sheet.
In contrast the SNP have all the money (public money), an organisation, a strategy, years of drip feeding lies and disinformation to everyone from the cradle, through a highly biased education system, to the grave, and a message that resonates with their target voters.