Oh it only makes one at a time? Can you remove improvements from tiles?
Well you should be able to remove improvements in order to get basic resources added to the tile with this satellite.
But one would use this satellite probably only in new cities that have to grow fast. In older cities other satellites might be more useful anyway.
If it can make bonus resources on sea tiles...
This. Can you imagine adding 6 or 7 fish to a coast city.
I don't think the bonus resources will be worth the opportunity cost of leaving tiles unimproved and forgoing a more useful satellite. I'll probably use it on relatively new cities and once or twice on my capital, and if I have the production capacity and orbital coverage I might use some on neutral territory in preparation of a new colony.