In her memoir, Scotland’s former first minister is surprisingly candid about her sexuality and the collapse of her marriage – but yet more remarkable is her admission of her failings as a politician, and how she seriously misread public opinion on gender reform, says Simon Walters