The man who invented the weather forecast in the 1860s faced scepticism and even mockery. But science was on his side, writes Peter Moore.