The Sea Sparrow and the newer ESSM have a really good offensive anti ship capability that isn't that widely known for some reason. In fact, the Turkish navy ate two Sparrows in a not-so-friendly fire accident in an exercise about 20 years ago - the 2 missiles killed sailors and very nearly sank a destroyer class ship. The ESSM now, which as I'm sure you know are loaded in quad packs in the VLS mounts on USN ships, are a far better missile than the earlier Sea Sparrows they've for the most part replaced. Like Rich has said though, they aren't cheap, and are primarily used in an anti shipping role for targets out of gun range, yet still close enough that a Harpoon shot wouldn't be the best either. Now these smaller cheaper missiles can be used on future smaller threats instead of wasting ESSM rounds that are better off being saved for potential airborne and incoming missile threats.
I thought the same as you Bustr, seeing the launch rack on the newer AC130 models, what a B1B, B52, or the new future LRB could do with a triple digit launch of these little autonomous suckers over a crowded battlespace filled with targets on the ground. Targets that are overkill for JDAMs, even the 250 or 500lb class weapons, stuff like that. Maybe poaching on the sensor fuzed weapons patch a little, but more options in terms of weapons is never a bad thing.
I know micro sized sensors and drones are coming to large bombers, heck, the article right below the Griffin missile on Defense Tech today is about that in fact. Also, drones that will be used to stimulate future anti access/area denial systems, to get them to waste their rounds on cheap drones that also gather intel, and will be launched with a mix of attack drones/missiles will be the future of bombers as well.