Most sporting events and public works projects are overestimated. Tickets sales mostly go to the agent, tour promoter and act minus taxes, venue and tour expenses . Merchandise sold going to the artist. Staying in a Marriott hotel isn't largely being put back into the community. The $15 Swiftie Sangria or beers at the concert are going to a large food service vendor. With taxes, local restaurants and workers for the weekend, Pittsburgh maybe saw 10-20% of that total.
Funding sports stadiums, art venues or any specialty project rarely brings true investment back. Like the sin tax in Cleveland, Orlando/Orange County has a tourist bed tax that collects $500m a year and goes to fund tourism projects. We built an arts center a few years ago for $600m, get around $20-25m basic funding yearly and they want almost $200m to expand. The Camping World stadium/former Citrus Bowl wants $800m for a roof/renovations. The Amway Center and soccer stadiums ask for money every year.