I personally don't see anything wrong with Andrew as a character. The only problem I have is what that they even included him in the first place because he doesn't really serve that much of a purpose. I get that he's supposed to be Akko's (and the audience's) viewpoint character on how most non-magical people see the world of witches and stuff, but it was crammed in a way that just seemed careless. Plus, Akko herself is from the non-magical world. Couldn't we just...have her as our vessel to see that. Maybe encounter some Average Joes on the street or something? I think it still would have made the same impact but kept more room to develop the other characters and their relationships. Just my thoughts, though.