With rear-wheel drive, acceleration transfers most of the vehicle weight to the rear wheels. That's why funny cars do wheelies. That doesn't work so well for front-wheel drive, so those vehicles can't accelerate as quickly as rear-wheel drive vehicles. With four-wheel drive, weight transfer cuts both ways, but more rubber on the road helps, for sure. Low center of gravity helps too, I think.

With wheels on the bottom of the car acceleration transfers weight to the rear axle. The forward forces on the car body are below the CG so produce a net rearward tilting torque.

Yes. But my point is that, with front-wheel drive, that transfers weight away from the driven axle.