This is a football stadium, so the expectation that it will "transform" the area into something lively on most days is in my opinion entirely unrealistic. Unlike baseball, Football games are only played once a week. Restaurants and shops can't thrive on such sporadic attendance. There are already a few places on Marietta that serve gamegoers and the patrons od occasional special events (Final Four, SEC, etc.). The surrounding neighborhood can't patronize these places itself. Therefore, I don't see this stadium really chaning much.
On the other hand, I think a redevelopment around Turner Field could be transformational as games are held more frequently, there isn't much nearby now, and the neighboring communities have enough money to eat out.
We need to think about how to help Vine City, but that help would probably best come in initiatives focused on education and social programs.
That said, I hope the design does interact with the street more and feels less boxy. Turning the old Dome site into a park with grass would be a great step, but I understand the plan is to pave it for parking.