Sadly, it is unlikely to work. If you read the reviews that expansion card only accepts type B M.2 SATA drives.
This one should do what you need.
I had the same problem with a Dell G5000 that has a Dell BIOS. I never did figure out how to get proxmox to work with the onboard m.2 a lot. I ended up adding an additional M.2 slot via a PCIe expansion card. Worked immediately.
ACTIMED NVMe PCIe Adapter M.2 SSD... https://www.amazon.com/dp/B09FLGR1X9?ref=ppx_pop_mob_ap_share