A "payoff" is money obtained from an investment or a gamble. In general, the term means a positive result for some action.
The attack on BP pleased some people, and it resulted ("paid off") in these people thinking more favorably about the administration.