Probably not a lot as I imagine the event organisers are behind the catering and of course ticketing so perhaps he gets a nominal fee for usage of the stadium? Speaking of SJP as it’s a leasehold, do the council get money from concerts? The City itself will have had a canny little boost, hotels, pubs, restaurants and retail.
The big winner is obviously Ed Sheehan and his agent/promotors and the supporting acts getting exposure etc.
It’s the Freeman who own the land the council get nothing. And no the Freeman won’t get any benefit from the concerts as the club pay a set figure each year which is usually re-negotiatied depending on what division the club are in.