Seriously, the flip command worked correctly. You expected the footprint flipped on the vertical axis but it was flipped on the horizontal axis. Select the flipped footprint and click R (rotate) twice.
Yes man, you are ABSOLUTELY right. I was being stupid. And I had already done it the right way before. I am doing a series of Keyboard PCB design and here’s me doing what you described on Episode 2 of the series: