The picture data shown includes about everything Except the basics, the essentials: ISO, shutter speed, and aperture.
Remember back in the day of the F2, cameras were manual, and we got to deal with those settings.
Auto mode has a big following though, all the compacts, and it is convenient, but it allows no way to control it ourself, or to learn anything. Auto users probably don't even know what ISO, shutter speed and aperture they are using (they would have no control anyway). And Auto does enable Auto ISO, which will be a problem for flash, and white balance. I'm just saying there is no probable way to improve the Auto flash picture in all that incandescent light.
The ambient indoors is dim, low level (compared to sunshine levels for photography outdoors), and generally unsuitable for photography, which is why we use flash indoors. The first thing to know about camera metering is that it meters the ambient (not the flash, the flash has not even fired yet), and adjusts the settings
for the ambient, which is quite low. That means very high ISO, and wide aperture and slow shutter (for the dim ambient).
Then reach up and enable the flash (open the flash door), and the shutter speed jumps up to 1/60 second. That is NOT metered, there is nothing 1/60 second about the light, but since we are using flash, then we don't need 1/4 second or whatever slow speed it was. Then regardless of the light, the 1/60 is simply a Minimum shutter speed. It will underexpose the ambient, but we are using flash instead. We don't even care about the ambient. It's dim and out of the picture.
Except if we are stuck with the very high ISO, then it does help the ambient, brings it way up into dominance, but then adding the flash is too much. It's not really a flash picture.
The purpose of Manual mode for indoor flash is that since the ambient is too far down to even care about, then we don't worry about it. We are specifically using flash instead. We ignore the dim ambient, and set the flash power (or TTL automation does it) to make the flash right.
Since ambient metering is don't care (in dim indoors where we plan flash), Manual mode lets us bypass all the pointless ambient considerations (pointless for our flash picture), and choose a low ISO, and choose an aperture for the flash power (instead of for the ambient), and choose a shutter speed to control how much, if any, of the ambient that gets into the picture. A fast shutter speed (1/200 second) keeps most of the (very orange) incandescent out of our picture (really helpful for white balance). A slow shutter speed (1/30 second) probably is not a full ambient exposure, but it does let some significant portion of it in. Not as much as your very high ISO let in however.
Re white balance... we really cannot mix light sources, like incandescent and flash. Incandescent is orange, and flash is towards blue. That's why your back row is orange and your front row is towards blue. There is no one white balance possible that makes mixed light be all correct.
When we are determined to use orange incandescent light in our flash picture, the we use an external flash (hot shoe flash) with an orange CTO filter on it, to make its light be orange too. Then we can choose Incandescent white balance to match all the orange light.