There's a deeper reason why Meemaw's house was destroyed in the Young Sheldon season 6 finale.
As revealed by Missy actress, Raegan Revord, the decision to destroy Connie's home in the Young Sheldon season 6 finale was rooted in an upcoming change to where the studio will film. Read her whole explanation in the caption of her post below:
For context, Meemaw and Dale had to spend the rest of the night in the illegal gambling den while the tornado passed by Medford in the Young Sheldon season 6 finale. It wasn't until the morning after that Connie realized what had happened to her home.
Meemaw's house getting wrecked from the tornado wasn't the only problem she had in the Young Sheldon season 6 finale. Early in the episode, Pastor Jeff accidentally discovered her illegal gambling business while doing his laundry in her legitimate establishment. Considering the Cooper neighbor's judgmental and self-righteous personality, there were concerns that he was going to blab about it in an effort to shut it down.
After discovering what had happened to Connie's home, however, Pastor Jeff surprisingly promised that he will keep her illegal gambling den a secret. As Meemaw's primary source of income, this means that it will be fairly easy for Sheldon's grandmother to not only get by in the next couple of months but also eventually rebuild her house. Despite George's offer, Connie decided to stay with Dale instead while she works on getting her home back up. Depending on when Young Sheldon season 7 picks up, the couple may still be rooming by then.
In Young Sheldon season 6, Meemaw's arc was focused on helping Mandy and Georgie leading up to the birth of Baby Cece. Considering her new housing arrangement with Dale, it's curious if the pair will fully rekindle their romance following their unexpected split. If that's the case, it's curious if Young Sheldon will once again complicate the situation by reincorporating Dr. Sturgis into her life.