Artillery in R:TW has one purpose: assaulting the city on the turn you arrive, instead of having to siege it for a turn or two so you can build siege equipment.
It fulfills that critical role like nothing else can. But otherwise, yes, it is not as effective as archers.
Grey Wolf