More (various styles):
Stop Draggin' my heart around (Tom Petty and Stevie Nicks)
The Look (Roxette)
U Got the Look (Prince & Sheena Easton)
When the Stars go Blue (Bono and the Coors)
Anything by Lacuna Coil, but that's really heavy and obscure to most people.
Close My Eyes forever (Ozzy and Lita Ford)
Rebirthing (among many others) by Skillet (Semi-mainstream Christian rock)
Various Arcade Fire songs -- most are mostly male, but some have the ladies more prominent
Work by Jimmy Eat World (more of a prominent female backing than a duet though. Liz Phair!!)
Somebody that I used to know by Gotye...but I think that one's run its course for now. And not really rock.
Steal My Sunshine by Len
Shiny Happy People (R.E.M. w/ladies from B-52s)
Other stuff from the B-52s, for that matter.
I think most Sonic Youth songs were either mainly Kim or mainly Thurston, but there might be some that qualify as duets.
Edit for MORE:
Don't you want me baby (Human League...new wave!)
What have I done to Deserve this...Pet Shop Boys with Dusty Springfield...but it sounds pretty much like two female parts in some parts.
Well, did you evah (Iggy Pop and Debbie Harry)
This Mess We're in (PJ Harvey and Thom Yorke, but maybe too out there)
Roadside by Rise Against -- amazing song. Doesn't rock out, won't get them moving, but it's awesome.
Go Your Own Way (Fleetwood Mac...more of a Lindsay song, but Stevie's in there prominently on the chorus)
Falling Slowly (from Once -- Glen Hansard and Marketa Irglova)
She has a girlfriend now (Reel Big Fish)
Make You Smile - +44
Candy - Iggy Pop and Kate Pierson ... those B-52 girls got around in the early 90s.
Southside - Gwen Stefani and Moby
White Balloons - Sick Puppies
Wild Night - John Mellencamp and Me'Shell Ndegeocello