I can provide some perspective on realignment because I live in Columbia MO. I haven't attended a Missouri football or basketball game in years because I have no interest in the SEC. I'm not alone. Last year for our designated "rival" game vs Arkansas the athletic department gave out 5,000 free tickets just to push the official attendance - not turnstile - to 50,000. Actual estimated attendance for both football and basketball is poor. For a weekday SEC basketball game there are maybe 4,000 to 5,000 in the seats.
In football Missouri is in the SEC East. The designated cross division rival is Arkansas every year. That leaves one game per season vs the SEC West schools Alabama, Auburn, LSU, Texas aTm, Mississippi and Mississippi State. Once every 12 years Missouri plays Alabama in Columbia. That's only technically being in the same conference. That's what you get with the huge conferences. Athletic director cashes a fat check every year from the SEC network but fans like me lose interest. Football stadium just got a $100 million dollar upgrade consisting of more luxury suites and a new locker room. Watch the next Missouri home football game if you happen to the the SEC Network (I don't). You will see a half full stadium except for the luxury suites. 30,000 is close to the actual turnstile attendance and that's if the team is winning. We now have 2 softball stadiums. That's for softball which loses money every year. The old one sits unused. This will be the third consecutive year in which the Missouri athletic department has operated in the red. Fat check from the SEC + big donor cash on one side - loss of blue collar fan support on the other side.
In basketball Missouri has 3 designated "rivals". Arkansas, Mississippi and Texas aTm. Those are they only schools Missouri plays every year home and home. Note that none of them are in the SEC East which is where Missouri is for football. The schools Missouri plays every year in football - none of them are home and home for basketball with the exception of the "rival" Arkansas.
Be careful what you wish for. The grass isn't always greener.