Does Burned & Pillaged, played on let's say Ghaston Grey, turn it into a 'gold-producing location' for the purposes of Support of the Kingdom?

Yes, I believe so. The card is given an income modifier, it becomes an income source, even if it is negative.