When you have a site not working properly, try changing the user agent to Firefox (or IE) and see if it works properly afterwards.
Right-click an empty part of the page and choose "Edit Site Preferences" from the menu. Select the Network tab and change "Browser Identification" to "Identify as" or "Mask as Firefox".
I just tested this on Apple's site using Opera on Vista. As you mentioned, the trailer didn't work properly for Opera, but after I changed the Browser Identification and reloaded the page (important!) it worked as it should.
This change will only affect the site you do this for, which is a very nice feature overall (per-site preferences). From this menu you can also change pop up preferences, Javascript options (including disable), cookie management, animated images, etc, etc.