Yes, missile silos turn into Positronic AI when destroyed. AI chip can then be collected.
There are several tactics to destroy a silo. I've had a lot of fun playing with my friend as a gunner - it makes it a lot easier. But still, having a decent upgrade to weapon doesn't hurt.
