Millions of lives were improved by reforms in the 1960s and 70s, from anti-racism laws to equal pay – yet many voters see his tenure as a failure, says Guardian columnist Andy Beckett