Sadly, No

A soccer stadium with less than awesome public transit access and highway offramps that essentially go right into the parking lot is not going to revitalize anything. People will drive in, watch the game, and drive out.