Hey, I can use his results while still decrying him. And I intend to. I call it standing on the shoulders of giants while chipping off their faces.

Seriously, though, you're right. One shouldn't dismiss all of people's work just because they were wrong about some things. But whether someone is a 'great scientist' is a bit unimportant in that sense.