The A330 with long-haul product is certainly better, however there might be a change that you will get a regional A330. The herringbone seats on the 747 is certainly by no means a bad product, but some might think that they feel rather narrow and constraint.
I actually don't mind either long-haul product but you might be putting in a gamble with. The A330 for. A regional aircraft where you will be guarenteed a herringbone seat on the 747