I absolutely hate the idea of a dome, and any thought that a Super Bowl will come here is a fantasy.
Domes are awful, look horrible on TV, and feel like playing in a basement. Just watch a Saints game. They look like they take place at 2:30 in the morning on a green outdoor carpet from the hardware store stretched over concrete. It's dark, dreary, and hard to watch.
Also, "retractable roof" is just another way of saying "roof that is always closed." It's pointless and adds hundreds of millions to the cost.
A dome itself pretty much doubles the cost of the stadium. A simple cost/benefit analysis is enough to see that whatever benefits come from playing in a basement (at the worst) or an airplane hangar with the front door open (at the best) are outweighed by the ridiculous costs associated with ruining the experience.
Steelers, Browns, Bears, Bengals, Chiefs, Packers, Patriots, Ravens, Eagles, Bills... all outdoor teams that play in winter weather.
A new stadium will cost plenty without a roof of any kind. A roof doubles the cost and ruins the experience.