He became one of the most famous U.S. soccer players after his goalkeeper plays in the 1994 World CUp