I'm guessing there's basically no chance Detroit ever hosts it again?
Min, Indy, Det were awarded a SB due to their cities contributing to a new stadium. They are not getting another SB. It's a one time thank you to give the city a one time boon on tourism for SB weekend.
It does seem like the NFL is preferring LA, SF, LV, AZ, Mia, NO and their main 6, with ATL (they have some bad weather at times in mid Feb.) with Ten likely to be part of the mix when their new stadium opens.
I do wonder if the 2 Texas stadiums are going down further on the list moving forward. Dallas, will be 17 years at least for them. Houston, LA will have hosted twice since they last hosted, and SF who hosted the year before Houston did last time, is getting another one.