It would take a slick archer to still hit you, you could possibly tie a 1 pound oil soaked rag to an arrow, set it on fire, and launch it a short distance. . . .but if the archer were unprepared for it, I can't see them hitting something. . . then again, if you failed your RR and had what felt like a 1.15 pound arrow in your hand, you might drop it for a fresh one. . . crossbow might just feel like somone was pressing it down with their finger, or the archer was tired. . .they might not "get it" until after they pulled the trigger. . . .
Then again, it doesn't make the arrow heavier, it doesn't pull the object in that direction, it just pushes against it away from moving in the direction indicated. . .the "float" thing above wouldn't work all that well. probably the one reason this would actually really screw up an arrow is that arrows tend to spin and wobble a bit in flight, and this would definitely throw off the shot. . .but I'm not sure by how much, and the archer would still get an RR. . ."Away" might work. . .I'm not sure. . .have them pull the calculators. . .If a .15 pound arrow is pushed to 120 F/S then it's:
(simplifying, and assuming no other drag or gravitational factors matter.)
0.15 x 120 f/s = 18 fp/s
1 pound back toward the archer is
1 x 32 f/s = 32 fp/s
so that would mean
18 fp/s / 32 fp/s = 0.5625 seconds to reach 0 f/s
I think that's right, I could be mistaken. . . .that's cutting it pretty tight, a crossbow bolt can go pretty far in 0.5625 seconds. .
120 F/s x 0.5625 = 67.5 (Which is a gross approximation to avoid figuring out the curve of velocity change vs time and how that translates into a total distance.)
So it might not be all that good an idea if you're standing too close. . .
That's a lot of hand waving away details, or other issues like "Would the preference NOT to travel forward cause the arrow to veer off, and once turned, actually wildly change direction."
Even the basic math is probably not worth doing at the table, much less hardcore physics thinking on it to the point of covering all the odd angles. . . it's an interesting discussion topic, but it might be too much figuring to do when actually playing. ("Stop, let me figure the velocity conflict in this arrow before resolving the attack." might lead to your players beaning you with dice.)