The attempt was on Charlie though, not the President. And it was by white supremacists, so it had nothing to do with the public opinion about the administration.