I hope it does mean the end of the weapons of mass destruction we have north of Glasgow, removing Trident is one of the major reasons for voting yes to independence next month.
This is nuclear NIMBYism. If you are worried about the base itself being a target for a nuclear or terrorist strike, such an event would affect the whole world anyway, not just Glasgow.
They would just move it to England. Or Wales.
This might be the least intelligent question I've seen on Slashdot.
Perhaps you should RTFA; an alternative that is discussed is to move the system to the USA.