What do you call a person that lives in Charlotte?

Charlatans

A native of Charlotte is called a "Charlottean."

A "charlatan" is a person "making usually showy pretenses to knowledge or ability" (from Merriam-Webster's Online Dictionary).

Given the definition of a charlatan, you can see why we prefer Charlottean.