Thousands descended upon rocker’s hometown of Birmingham to give the city’s prodigal son a fitting send-off