Just adding voice here I think they really fit in with fire support.
A direct example was I had a destroyer (i think medusa, the fast energy one ), and fires support condor with LRMs. The fight was wrapping up with us against a larger ship(forget which kind). But the tactical gyst was that the enemy had directional shields and way too much firepower for me to get close enough to hurt it without getting annihilated.
The LRM's coming in also were just not reaching the ship, or just bouncing off the shields generating negligible flux.
But, combining the two useless weapons I had, we were able to take it down.
I parked myself on the opposite side enemy from where the LRM's were coming in in regular intervals. When the LRM's would come in, the enemy ship would have to start firing PD and change shield directions or risk taking the missiles on the hull. While the PD and shields make the LRM's do next to no damage, actually impacting armor, they will start to hurt.
When it did that, I would close up to my gun range, fire all I could against the exposed hull, then back out again until the next volley.
So individually the LRMs were useless, but combined, using their regular long range harassment, I was able to take down a much larger ship.
I think they have really great tactical uses. They are annoying in that you can avoid them when they are the only threat, but combined with other attacks, they become outright deadly, and hence, the definition of a good fire support weapon.