The view of the Scottish electorate has continued to be to return a govt in favour of independence. Your conjecture about the next election carries absolutely zero substance - unlike the elections of 2015, 2017 and 2019 plus the elections to the Scottish parliament in the same period.
You maybe missed the SNP taking the matter of pushing for another referendum to the Supreme Court - not sure how that aligns to "shat it".
Northern Ireland - a much more contentious landscape - has the term generation defined in the GFA. We're already well past that definition in Scotland so your inference that the people of Scotland should get back in their box is laughable - except in a country where there is no legal means of delivering on a mandate repeatedly given by the people of that country.