That's where I think it differs from case to case. Some people use it as an insult, but that's not always the case. Mental illness isn't insulting just by itself, and so if someone doesn't understand something as radically different as transgenderism, mental illness might seem like the best explanation. It's not always used with ill intent. Whether or not it's insulting in those situations is dependant on the feelings of who it's directed at.