Usually teams do not change it to a completely new thing, they just add something in. Meaning it would be like "Red Bull Old Trafford" or like "Visa Old Trafford" etc etc, basically keep the name, add the sponsors name and that's it, that's all they do normally and I am expecting the same to happen.
Plus, fans do care about the titles and achievements, not the names, you can change the whole United team name if you can, as long as it means titles, you can't change it I think but you understand what I mean. If they can get insane amount of money from it, and get some amazing superstars, and get titles thanks to that, then nobody would care what the stadium name is. At the very least, we have some business savy person at the helm after many years.
Changing the name completely would take away the historical value that they have gained in the past so Old Trafford is no longer a name that is always remembered. Of course there are many considerations with the name because the stadium has such a long history for Man United. At least they don't lose the essence of the whole thing so the name is still the one that is maintained even though there is a syllable added in front of it as something new.
Name is also important although the title is a very crucial dream and now Old Trafford is no longer a scary home for opponents because it has lost its direction in the competition. Sponsors are indeed very necessary but there must be another way so that Old Trafford remains the name of the Fans' proud stadium. Football always involves business and that is what the previous Man United management did so they only cared about business not the success of the club. Now a new direction will begin and Man United will try to make big changes to bring the big name back.
You are right that historical value must be a consideration for anyone if they want to change a name, be it the name of a stadium or so on. The reason is that their big name in the past cannot be separated from the name of the stadium they occupy, which is currently their headquarters. Yes, even though we know that Old Trafford is no longer as "terrifying" as it was in the past, historical value or elements are still attached to this name. So they should consider changing their name.
I heard they are considering this because they want to renovate, and this name change is a consideration so they can attract big sponsors. But in my opinion, are they unable to convince sponsors without the lure of changing the name of the stadium? I think they should be able to do it.
The reason is that this is related to history and history is a very valuable thing for a team, maybe they will always remember that history, but when the name changes maybe the atmosphere will change a little. So once again they have to consider it very carefully.