I don't think we should belittle the very great mental and physical strength and dedication needed to excel in sport these days, and we should acknowledge his achievement in being the first British man to win a grand slam event for 75 years. But I agree that is not the same as heroism in the sense of the bravery exhibited in the theatre of war, or someone risking their own life to save another.
I do think he will appear as a hero to all those who have tried very hard to lift British tennis to world class status though.
I have never been to Dunblane but I understand it is a small town and especially after the massacre, probably has a strong sense of community, so I expect people will turn out to greet him.
I think if he came from the Northumberland village where I live, I probably would!