Good advice. Should still be able to add sand later.
Looking at 2.8 or 2.9 meter long screws, so rotating screw would probably run into whip problems. I haven't done the math yet to see what critical speed would be.
I have built a rotating nut before, for a quill drive on a 3-in-1 lathe/mill/drill. In that case, the rotating nut was mounted to the machine head, and the non-rotating (but translating) screw was attached to the quill using a banjo, see below. In that case the reason was clearance and travel, not whip...
Attachment 480396
Rack & Pinion candidate: https://www.ebay.com/itm/294594387439 (two sets needed) with a 10:1 planetary gearbox between stepper and pinion
Ballscrew candidate: https://www.ebay.com/itm/143428535452 (contains two screws and nuts) with a roughly 2:1 belt reduction from stepper to nut