Ehhhh, I mean it's conceivable that there were some reasonable use cases for it, but in reality it was just a massive foot gun. I remember trying to debug some old VB6 code in the late 90s that used On Error Resume Next all over the place, and it would get into some unbelievably funky states, it was a miracle that it worked even some of the time. The truly scary thing about it was that even some system level errors would just get swallowed up and you had no idea that Really Bad Things(TM) were happening under the hood.
The equivalent to try/catch in VB was On Error Goto <ErrorHandlerLabel> which when used properly was more or less fine.