Not only did he redeem himself, he was forgiven by his future incarnations and they called him "Doctor."
That's enough for me to renumber The Doctors. However, I know this will be hotly debated for years to come and there will always be confusion when talking about The Ninth, Tenth, Eleventh, Twelfth, and upcoming Thirteenth Doctors (and all of the future incarnations).
I don't think there will be. Moffat has already stated that it doesn't change anything and that Smith still is the eleventh Doctor, so the point is moot and it's only really confusing for people who want it to be confusing.