I'll have to look up the numbers for the other movies with big domestic openings, but here is my intuition before I apply the appropriate ratio.
I do not think it will have legs like The Force Awakens and Black Panther. These movies had a special appeal beyond the core fanbase of hardcore Star Wars and Marvel fans. Also they seemed especially geared toward repeat viewings.
I think it will have better legs than (proportionally) than Endgame and probably Infinity War too. I remember Endgame in particular had a mindblowingly incredible opening, even to the point where I saw it on a Monday and the theatre was still jam packed. (I saw it a few days earlier too.) However, it's legs were pretty terrible and at least the worldwide total just barely inched above Avatar in spite of it having a much bigger opening. (I think domestically it had poor legs too.) The main reason it's legs were so bad is that people really did not want to be spoiled. They felt they had to see it ASAP, because spoilers would be everywhere as soon as it came out.
Well, I think Spider-Man:No Way Home will (proportionally) have legs somewhere between Endgame and Black Panther or A Force Awakens. It is another movie where people really do not want to be spoiled. However, I think it will also be the main movie to watch in December and probably January too. Outside of the Summer, December seems to be the best time to launch a movie, and usually one or two exceptional movies have really good legs because of the season. (This could be a Star Wars movie, but it could also be a movie like Jumanji or The Greatest Showman.) No Way Home kind of has the leg shortening factor of Endgame and the leg lengthening factor of A Force Awakens. I would have to see what the ratios are of total/opening weekend and then probably split the difference for No Way Home.