moonroofs are overrated IMO. i have one. i never use it. i keep it closed during the winter, DUH, and i keep it closed during the summer - when the ac is on. i never fully open it. i keep it cracked open when it's hot out and i have to park under the sun for a long time. that's pretty much the only thing that's good about having a moonroof. i wish i didn't have it because my head is right up against the ceiling and the moonroof takes up an inch or two.
that being said, it's never a good idea to put a hole in your car that's not supposed to have a whole there. i would think that would affect the rigidity of the car. and there is also the too-common leakage. if you really want one, however, follow speechless' advice and go ask an acura dealer. they would probably want an arm, a leg, and your first AND your second borns for it. good luck with that.