I'd say both of these uses of "he was shot" make sense:
- "How did he die?" -- "He was shot in the street" [meaning shot dead]
- "He was shot in the street, but luckily the bullet only hit his foot." [meaning shot at -- there was a bullet coming his way]
Would you agree?
And what would you think of a headline "He was shot in the street". Is the man dead or was he just 'shot at'?