While twat has come to mean an unintelligent person, it could still be found insulting, as it is also slang for vagina.
I myself noted the name and, being from Ireland, assumed it was meant in the way you described. However, it certainly can be thought to be insulting.