The presenter Lucy Worsley examines exactly why Conan Doyle fell out of love with his celebrated creation