Let's say that someone had the ability to fire off a bunch of little red beam-like things everywhere. Would you think that was a "special attack"?
...Maybe? It would depend on how much damage it did, how strong the character was, and how fancy the attack looked.
That happens to describe our good ol' bloody-shotgun-whose-name-I-forget. Which doesn't require SP.
Oh, I almost forgot. How about if you instead saw a red beam? Well, that's pretty much what the dragon's attack is, isn't it? It also is what we had with that lovey sniper rifle we had, and that knife. Neither required us to spend SP to make the attack.
They required SP to make, and are weapons, not natural attacks.
And yet we could use them endlessly.
Regardless, the concept is there. You can't assume that just because it looks like it could be a spell, it costs SP.
All ranged weapons use SP, they function endlessly because we put MSP into the weapon, which is special I guess.....
No, they don't all require SP.
Throwing rocks, shooting arrows, and such do not require SP. Why would you assume that all ranged attacks need SP when the only ones that do fall under the category of spells?
But such weapons would have ammo constraints, and therefore would be largely temporary
Alright, let's go with something a bit more speculative, because we have seen very very few ranged weapons.
Imagine that Ciro was a acid-spitting monster. Would the acid take SP to spit?
It technically did, because the shotgun is made from MSP.
And why can't this apply to the dragon? Why are MSP-investing things the sole realm of PCs?
The Shotgun uses the Fire! Spell on itself, so it wouldn't have to calculate penalties from Antimagic 
Where is the evidence that such a spell exists?
You know, it does bring to question why the town guard had an 'illegal weapon of murder'. It was probably called that before Al killed him, I mean he didn't kill him with it so it isn't his weapon of murder, so who's is it?
Maybe he confiscated it from Mordor?