How does AWD affect mildly powered cars? For example a non WRX Impreza.

I guess the heart of the issue for me is, does AWD have any performance advantages when you’re driving under the limit; or does AWD just bog down a weak motor with additional parasitic losses? I know those two aren’t direct opposites, so the answer could be different depending on the scenario.

For a specific example: Let’s say you’re launching a FWD right below the limit of any wheelspin. Now if you where to give that car AWD and launch it just below the limit of any wheelspin; would the AWD launch be faster than the FWD launch?