The real Queen City, thank you
Raleigh is much more organized right now, but they kind of have to be to combat Charlotte. The Raleigh metro isn't particularly conducive to a team, with three large, distinct populations spread out over about 113 square miles. Durham to Raleigh is about half an hour, and you can't rely on half of your population to drive half an hour or more see the team. Diehard fans sure, but you're going to be drawing mostly from the city proper. The Research Triangle, Raleigh's CSA, is about 700,000 people smaller than Charlotte's, and the TV market is also smaller, though not by much here. The corporate money is also much more prevalent here as well as we have 9 Fortune 500 companies with headquarters here while Raleigh has... 2, not to mention other companies with regional headquarters in the city.
Both cities are held back by the fact that neither of them have a stadium. Raleigh loses to Charlotte in just about every metric - the only reasonable argument for the Triangle over the Queen City is that Raleigh only has the Hurricanes to compete with. But in the MLB Raleigh site you mentioned, while they reference the Hornets' attendance struggles, they fail to mention that the Hurricanes also don't draw well, in fact, they've draw worse than the Hornets recently. If the MLB announced real expansion or it was seriously under consideration for a franchise to move, I guarantee you somebody in Charlotte would step up, whether that's David Tepper or another one of the rich guys that make the area home.