Nicola Sturgeon urged to 'get on with the job' and move on from 'incredibly depressing' independence debate