A lot depends on what you mean by "hit". The '91 production ran for a respectable 706 perfs, but did not recoup on Broadway. There was a tour that ran over a year. Anyone know if Secret Garden recouped as a result of the tour?
If you mean a commercially successful revival, you would need casting that would guarantee sold out performances for at least a year. So something like Hugh Jackman as Archibald, Nathan Lane as Neville, and Ben Platt as Dickon (or actors with similar drawing power). Just IMO.