The acting director of the US Secret Service has said he is "ashamed" of the security lapse prior to the attempted assassination of Donald Trump.