Except it's not transphobic, but is instead insensitive. I don't know Mr North, but being a public figure and posting on his own public twitter account, I don't think there was any malice or "ist", "ism" or "ic" intent. So no, Bungie should not take any steps to stop working with him or get involved.