Mayor Pete is an insult because it reminds people that his only actual political experience is being a not particularly successful mayor of a medium sized city. He has no accomplishments to point to, and since he's transportation secretary, we can point out that South Bend isn't a beacon of shining infrastructure.
Gay Pete is just a description.