SCREWED this morning!!!!
Update: Not screwed anymore! Yay! Rod Glover went out and took out the screw, which did not puncture the tire - really minimal damage, it wasn't very long, and entered at an angle. Put some Ride On in the tire just in case, and everything is A-Ok.