The verb pique means to make someone angry or annoyed. But when something piques your interest or curiosity, here the verb pique just means to arouse, stimulate, or excite.
Both the noun and verb are pronounced "pēk" and were borrowed from a French word meaning "a prick or irritation," from Old French piquer, "to prick." So you can see how something that piques you could make you both excited and angry, perhaps even enough to storm away. That storming away, by the by, might be called a "fit of pique."