A 3/4 horse pump with a 200# sand filter shouldn't generally be a problem. Usually that size pump won't flow as much water as the filter can handle, so it's OK. But a 1/2 hp (full-rated) would work well, too, I'd presume.

7 years is an awfully short life for a Hayward SuperPump. Mine's still going strong at 10 years. Unless it was faulty I'm wondering if you damaged it somehow and if it's fixable.