So I had to look this up, because that Tesla factory does employee thousands of people, and it manufactures their superchargers, has an AI datacenter in it, and a bunch of desk jobs, so I wasn't sure what was failed about it.
Originally, it was supposed to be a solar panel manufacturing facility, but that didn't really pan out. There was a quota to employ a certain amount of high tech manufacturing jobs, which was later changed to just manufacturing jobs, and then just jobs.
So while the factory is there and functional, it's definitely not what was intended when it was built with certain requirements set on Tesla (or whoever would have won the contract), and what it does now, doesn't bring in anywhere near the expected economic boost that the original intended plan would have.
So in that sense I'd say it's definitely a failed project yes. But the factory is there and functional.
Edit: Also looks like their lease is coming up in a few years, and theres opposition to signing a new deal with Tesla.