How graphic are the graphic novels mentioned in your linked story? Does it matter to you?
Also, what is the purpose of drag queen story hour? Is there a goal associated with it?
It’s a public library. I personally think they should be keeping books that their patrons are interested in reading. If graphic novels are what they want then sure, what is wrong with that?