Nicola Sturgeon spoke of feeling she had ‘failed’ when she did not win the constituency she stood in at the first Scottish Parliament election.