There is massive appetite & it grows every day. 60%+ want it - yes, uncertainty remains over timing (1,2,3... years away) & that's where lower % figures quoted in media are spun from most of the time.
Brexit has accelerated things by a couple of years & whats coming is big change OR big change, status quo isn't an option!
You will hear panic stuff in media saying there's no appetite (sometimes based on surveys) but for most part that's words parroted from UK Tory/Labour/LibDem party representatives/MPs etc scared they're going to have to form new parties in Scotland or be out of work (other than as independents).
Should Boris become Tory leader independence for Scotland is guaranteed, unless there's a massive reversal Northern Ireland will cease to exist in a few years time too.
UK gov can't squash indyref2, just delay permissions temporarily & the more they pretend they can prevent it the desire grows up here ... BTW SNP conference starts tomorrow