Hello
This is not a bug.
As @Stratelier has mentioned, the Weapon’s spell summons a random troop from the entire pool of the Drifting Sands. (Which means it can pull a troop that was previously used, as it is not excluded from the entire troop pool)
However, I can pass on your feedback to the development team for consideration.