Is tommy john surgery usually successful?

Yes. "usually" being the keyword - several sources report that tommy john surgery is successful is over 85% of cases, although the recovery/rehab time is extensive (the reason that baseball pitchers tend to miss an entire season).