Some National Guard members who responded to uprisings across the country after the police killing of George Floyd have said they regret how the situations were handled