Have done hundreds of hours in A330 (as pax) and will no doubt continue to do so in the future. While AF447 is most certainly food for thought, it shouldn't to all extents detract from the very reputable safety record the A330 holds.
As an aside, don't have much choice at the moment as all KE Australia ops are by A330s (-200 & -300).