I think you'll find that once society has moved on from the Queen that the Royal family will have a job on their hands in Scotland.
I would say that there would be a majority who would vote to get rid of the monarchy in Scotland with the Queen out of the picture.
The royal family as an establishment is under huge pressure to reform to a different model, possibly along the lines of Scandinavia or Holland etc.
Doubt it will happen under Charles who is part of the problem, may fall to William to modernize.
You only have to follow this thread to realize that most posters on here so far are not Royalists at all.