The controller was limited in that it's a limited edition, but it wasn't supposed to be limited before release. It had a hard release date that was supposed to be at the same time as the games initial release which was supposed to be in April 2020.
The controller is still being restocked but very short supplies and only Amazon is stocking them, who are the only ones who can afford the shelf space for another controller among the several different colors and limited edition controllers seen in stores for the Xbox One.
These are some of the current limited / special edition controllers sold at Walmart regularly;
- $50 Gray & Blue
- $50 Midnight Forces II Special Edition (Walmart Exclusive),
- $60 Night Ops Camo Special Edition
- $60 Arctic Camo Special Edition
- $60 Phantom Magenta
Not counting the standard colors Red, Blue, White and Black.
Stores aren't ordering controllers as they weren't selling on the same scale as any other Xbox One controller. It'll be different if there were only a few other controllers but stores have between 5-10 different variations of the controller, they aren't looking to get the least sold one to take up space. Didn't help that it cost $74.99 retail compared to $64.99 other special colors controllers retailed for. Even so, those other controllers were normally $50 - $60 at Walmart. Why pay $15-$25 more for a controller for a game that isn't out yet that average consumers doesn't know about. It was an easy decision for stores to stop stocking / requesting inventory for them.
The consoles are a different issue since they too were supposed to be released during the initial launch but didn't since the game was pushed back. Looks like Microsoft didn't want to wait (probably due to the fact that it included a digital copy of a yet to be released game and was announced after the Series X was), they and others did a fire sale and sold the console for $299.99 when it was supposed to be the same price as the Xbox One X at $399.99. For a console that is limited to 45k units worldwide, there shouldn't have been any reason for multiple retailers to try to get rid of it as soon as it launched.
None of those are meant to actually be limited like the ones for Gear, Forza, Tomb Raider, Sea of Thieves, ect. The Cyberpunk one came out at a time when it was almost impossible to keep any Xbox controllers in stock so price wasn't an issue. Amazon finding a few here and there doesn't change the fact that Microsoft no longer wanted to waste the shelf space in stores on something they weren't going to restock.