Odds heavily against Scottish independence in the next 20 years.
Bookmakers price a referendum before 2025 at about 10% probability. I think that's too big a number - I'd say 10% chance by 2030.
Let's suppose it happens in 2025, though. At that point, the UK and EU will still be at loggerheads over the border with NI meaning the SNP's central premise - that Scotland should be able to rejoin the EU - will look more and more like a dangerous and economically calamitous poison pill. Even pro-independence financial analysts will warn of a deep recession with house prices falling off a cliff. That'll make independence about as popular as mouldy bread.
In addition, the EU will be quite feckless and tone deaf to what that SNP promise of independence is centred on, and during any campaign will confirm confidently that yes, Scotland could rejoin the EU, all it'll take is adoption of the Euro (non-negotiable), and a complete adoption of all protocols and laws that the UK - including Scotland - will have mostly dismantled by that point (for better or worse). The timeline will be a decade or more, and the estimated costs will be in the billions, but the EU think it's still value. Meanwhile Scottish voters will wonder if a generation of being out of the UK _and_ the EU is worth the candle.
The idea that against that backdrop the SNP think their argument for independence is stronger, not weaker, is strange.
I think you'll also see a slight shift in polls in coming days and weeks because of the death of the Queen. Operation Unicorn is designed in a small way to allow Scottish unionists to show what the United Kingdom is all about. Sentimentality has been proven time, and time again, to be incredibly powerful in changing people's minds quite irrationally.
Coupled with Charles' political will - as you note, towards radical environmentalism and architectural protectionism that aligns neatly with a decent proportion of the Scottish populace - you might find Sturgeon and the SNP looks more and more marginal as time goes by.
The Queen oversaw a decline in Empire and a rise in the British believing in - and committing to - a people's right to self-determination. And so it will be in Scotland, just as it has been for so many countries that have gained independence from British rule in the last 75 years. But the backdrop right now is firmly that the SNP is about to slide, independence will become less popular to many, and Scotland will either be part of the renaissance we are all hoping for, or is coming down with the rest of us.