There are several ways to nerf this, if considered too powerful. But I like to reward my players for creative ideas like that. And it's not really powerful either. You shoot non-magical cannonballs. That's OK.