Having looked deeper into this connection I've found that Charlotte McSparron Betty married Robert Thomson in 1804 at Portsea, Hampshire [genforum]. Charlotte McSparron and Robert Thomson had a son Paget Thomson in 1815 at Edinburgh. Charlotte McSparron Betty and Robert Thomson had a son Alexander born 1817 at Edinburgh [familysearch]. Charlotte McSparrow Beaty and Robert Thomson had a son James born 1819 at Edinburgh. I'm unable to find any children born in the 10 years after their 1804 marriage. It is possible that Charlotte Thomson baptised in 1808 at Antony, Torpoint, Devon [findmypast] is another of their children, but I don't have credits to check if there is further detail.
The common link is the use of the surname Thomson in conjunction with the much rarer McSparron and Betty. Charlotte Thomson marries Matthew Watson in 1825 at Jarrow, Co.Durham. They have daughter Charlotte McSparron Wilson Watson baptised 13 Jul 1826 at Jarrow. Charlotte Mcsparron Wilson Watson marries James Wilson in 1848 at Berwick-upon-Tweed, Northumberland. Their family is that listed in the 1861 census previously.
I haven't found any link to the McSparron family, though they still live in Northumberland, they didn't arrive there until the 1860s. Nor have I found the first Wilson family link.