Would need a new connector spec to support the weight. CPU socket mounts are way sturdier than PCIe slots.
It wouldn't need to be supported by the PCIe slot. The edge connector would deal the electrical connection. Since the card is lying flat you just need support under the rest of the card.