Avatar: The Way of Water has broken one of Spider-Man: No Way Home's box office records with its massive opening.