Our team did a deep dive working with the Footprint Library and official specification and found several errors and inconsistencies with the official library itself and the specification.
I wanted to cross post this here for greater visibility as correcting these issues could be helpful for KiCad and the community moving forward: