McCain aims at the south with all his might.
It has all the ingredient for a good contrepet, but the result “all his sight” does not work as a meaningful sentence.
And the “sight” has no impact: it is not rude or politically meaningful. (Think about updating it for the next presidential race to Romney)
Again it may work as a spoonerism but not as a contrepeterie.