Presumably hoping to capitalize on Johnson’s extreme unpopularity, Nicola Sturgeon has announced that a new referendum will be held in October 2023. The moment has already passed, however. Boris will be leaving, and it is unlikely that his successor will raise as much ire in Scotland as he does.
The bottom line is that the two major parties both oppose Scottish independence, and that the ghost of the unauthorized Catalan referendum still haunts the cause. The only realistic way a second binding referendum takes place is if the SNP holds the balance of power between Labour and the Conservatives. When will that happen? Nobody knows, but it worked for the Irish, so be patient.