It will look terrible on a Video DVD! Why?
Because your standard Video DVD is "standard definition" so it's correct for you to notice how bad it gets.
AVCHD can be 1080p and you are dropping to 480p at best.
Not much new here. And as you will discover, as long as you want a Video DVD you can't get there from here.