YouGov polling for Scottish independence has consistently had remaining in the UK leading by 9-11% for a while now.
I'm not really seeing Kier driving Scotland towards anything. It's been broadly the same for a few years now. He's not driving Scots towards remaining in the UK or to Scexit.
If Novara Media's editorial position is that Scotland should have another referendum then fair enough, but I'm not really seeing good data on Kier causing a sudden surge in support for independence.
For what it's worth, FindOutNow thinks a slim victory for Scexit is on the cards, but I don't consider them a serious polling company... They're the same ones that put Reform way ahead of everyone else in polls, despite other pollsters having them in line with Labour/Conservatives. I genuinely think they aim to have results that get desired headlines (their funding model is, after all, to have polls commissioned by media companies).