The text deletion scandal surrounding Trump and January 6 may jeopardize the Secret Service's relationship with the people they protect, a former agent says