I've been there multiple times over the years. Taken the extended tour of the USS Missouri as well with my father-in-law who is a huge WWII buff.
One of the most interesting things about that site isn't just where the USS Arizona is located, but the fact that on the Missouri, you can find a plaque where the instrument of surrender was signed by the Japanese and Americans. The boat was obviously not sitting in Pearl Harbor when they signed it, but still, I think it's pretty cool.
So, you can stand next to that plaque on the USS Missouri, and in one shot get the exact place where the war started for America (USS Arizona) and the place where the war ended (USS Missouri).