It was apparently a collaborative effort, between the Wilson sisters, Michael DeRosier, and Roger Fisher:
Rock group Heart says "Barracuda" use is fishy
Fisher is the one that has been quoted as thrilled, as they get royalties and publicity. I've read that downloads of "Barracuda" has shot it to the top of online music charts. I bought my copy from iTunes long ago. :-)
He has also written that he plans to donate a portion of the royalties to Barack Obama's campaign.
As others have noted, this is out of the artist's control, anyway. From the article:
Copyright law may not be on the Wilsons' side as the song is licensed for public performance under a blanket fee paid by the venue to ASCAP, the firm that collects royalties on behalf of composers and copyright owners.
If the fees are paid, McCain's campaign can legally continue to use the song. If they stop doing so, it's only out of respect for the artist's wishes.