No, 400w of metal halide and 440w of VHO are not comparable. You will get A LOT more light from the halides.
Since the 75g is 48" long you are going to want two halides. You could get away with one if you used a good reflector like the luminarc, but it'll leave a nasty shaddow from the center brace.
Given that, dual 400w halides on a 75g is a lot of light, not overkill but IMO you are going to have major heat problems.
Have you looked into T5ho? A fixture with (6) 54w bulbs individually reflected would allow you to keep anything you wanted as well with a lot less cost and heat.
-Justin