If it can't fulfill this core function without the screw, it is valueless.
Of course, you can pawn the motorcycle for thousands of dollars, but for that, you would have to have a marketplace and buyers. You can also turn some parts into tools and probably repurpose the tyres into something useful.
But again, to do that, you would have to have the knowhow and the necessary tools and time for repurposing.
If you were in an isolated environment with no other people around and no additional tools, a motorcycle that doesn't function is as good as "valueless".