The camera would survive and probably even function correctly during that acceleration. The camera must be robust enough to withstand normal use, so it's going to handle a 10g static load just fine. Nothing in a DSLR depends on gravity to work, so 0g is fine. Extended time in an environment like a fighter plane will eventually break a consumer camera, but from shock and vibration rather than static g-loading.
I'd be more concerned with safely holding onto the camera in a fighter cockpit. The plane is designed not only to pull tight turns, but also roll and pitch very quickly. You don't want something like a DSLR bouncing around in there, as much for your and the plane's safety as the camera's.
There are cameras for this sort of application: no moving parts, small, light, easily mounted. Something like a GoPro costs less than the gas to get the plane off the ground.