Much of the support for expanding Asian trade is coming for states with the most to gain, according to a CNBC analysis.