He’s not the man to lead Scotland to independence, but after a turbulent few years, he’s the safe pair of hands the party needs, says Herald columnist Dani Garavelli