It is an insult. Please don’t try to explain away Jesus’ words here by saying that they wouldn’t have been insulting in Jesus’ day or that Jesus was just trying to test the woman’s faith. His words were insulting and, in some ways, they are even more pointedly insulting (with potential to cause harm) because of Jesus’ time.
