Nick Gordon probably has proven himself to be a major league player in his time with the Twins. That is, if he were DFAed, he would definitely be picked up by someone. He's a good player to have on the team because he has some speed and can play multiple positions. HIs hitting has progressed to league average at this point. I don't know if he played every day or even in a strict platoon if he would sustain his offense, but he has done well in the role he has with the 2022 Twins.
The problem, or perhaps more accurately the limiting factor, is that Gordon isn't a major league quality shortstop. He'd have the chance to be a regular somewhere if he could be trusted to line up at short for 130-150 games, but the evidence is there that he can't. When Correa first went down (fingers), the Twins brought up Royce Lewis and plugged him in at shortstop. When Correa went down again (COVID), the Twins brought up Jermaine Palacios and plugged him in at short. That says volumes about Gordon's ability to man shortstop on more than an occasional basis. It is a closer call in center field, but Gilberto Celestino is the preferred backup when Buxton isn't in the lineup.
To summarize, Gordon's improved hitting and ability to be a serviceable defender in the outfield has cemented himself a a major leaguer, his inability to defend well enough at two key defensive positions will most likely preclude him for ever being a regular in the majors. He's certainly not a failure, but he most likely won't ever hold a regular position.