The truth is Intel makes two versions of most of their WiFi cards: the normal version, and a "low cost" version where some of the internal components are missing and those functions instead offloaded to the Intel chipset on the motherboard.
Sort of like the "WinModems" of WiFi cards.
If you want one that works, buy the correct version.
The link shows the BE200 as the "M.2: PCIe*, USB" type in the highlighted Intel Ark screenshot. In contrast to the "WinModem" version you're conflating this with, which should say "M.2: CNVio2" (or similar) like the AX210 and AX211 pair.
BE200: https://www.intel.com/content/www/us/en/products/sku/230078/...
AX210: https://www.intel.com/content/www/us/en/products/sku/204836/...
AX211: https://www.intel.com/content/www/us/en/products/sku/204837/...
The BE200 should be like the AX210. The "WinModem" variant should be BE201 like the AX211.
Edit: I guess I should say that I don't know if "may be locked via Firmware" is a reasonable conclusion, just that the correlation is present, and the assumption of interface compatibility (given an M.2 slot with PCIe and USB).
Posting includes exactly that information, explicitly ruling out that the card is "low cost" CNViO RF module according to specification provided by intel - yet a post will ignore that :)