"Avatar: The Way of Water" delivered director James Cameron his first $100 million opening weekend — but missed industry expectations of $170 million-plus.