After checking in at the front desk, and getting your ticket (it's free, but you need a ticket), you will watch a short film about Pearl Harbor, which is very moving. Then, you board a launch (small boat) that takes you across the harbor to the memorial.
After docking at the memorial, you are on your own. There is a wall with the names of all those lost on the Arizona, and several small information signs around. The memorial is built directly above the sunken ship, so you can look down into the water and see the smoke stacks. Small amounts of oil are still leaking from the ship, leaving a rainbow gleam on the water. Some people drop flowers into the water as a memorial.
The whole visit is a very solemn, moving experience. Although I had no family members that died in Pearl Harbor, I found myself weeping softly. Tears of sadness for those lost, but also tears of gratitude. This visit really seemed to personalize the cost of the freedom that we enjoy in the USA.
It is best to get there early in the morning, as it tends to fill up in the afternoon. Some tour companies offer tours from Waikiki resorts, and will arrange your tickets for you - all you pay for is the bus ride.
Please remember to show respect and keep your conversations to a minimum. If you must talk while on the memorial, please whisper. If your kids can't be quiet, I would advise that you not take them, so as not to disturb the solemnity of the memorial.