I don’t know how the Secret Service can be expected to have done any better. Trump made an unscheduled visit to his 27-hole golf club, where he rides hither and yon in a open golf cart at his pleasure. A disgruntled former Trump supporter with a semiautomatic rifle never got anywhere near him. The only shots fired were fired by the Secret Service. The guy was quickly arrested.
I’d say they protected him successfully.