You’re not the first to one to get a footprint backwards. I use my own pcb cad program, so I have to draw each new footprint. Early on, I sometimes drew it on the bottom layer as if it was on top. Now, I have learned to always draw it top and the program mirrors it if I switch to bottom.
The only thing the Kicad library "may be good for" is to give you general idea as to what the foot print should look like. Even fancy layout programs like PCAD, Mentor PADS or Altium screw-up generic footprints. You HAVE TO VERIFY not only the footprint but the pin-out as well against the datasheet