Plans to transform a fire-hit former Sunderland pub into a convenience store have been blocked by councillors, following road safety fears and more than 200 public objections.