Nicola Sturgeon's future must utilise her 'formidable' skills for campaigning on indyref of Holyrood 2026, the SNP has been warned by Professor Curtice.