The SNP has failed to make Scottish independence 'relevant' to voters, says party's Westminster deputy