The idea of running 40 amps of current through an adapter in this situation is cringeworthy.
I'd personally begrudgingly spend the money for the BMW adapter, or buy a used EVSE with another adapter.
Almost every transition in an electrical system could be called an adapter. The breaker adapts the panel buss bar to the wire termination. The wire goes to a receptacle and that "adapts" the wires to a plug. Transitions to a brick, brick to J1772, J1772 to car, almost all 'adapt" or convert one form factor to another. Most are 'permanent" and don't move unless modified. My concern is any frequent connect/disconnect of a device. We frequently connect and disconnect the J1772 plug to the car without concern. IMHO, it's the design insertion cycles that matter. That's why I just don't "get" plug in chargers if plugged and unplugged on a regular basis. Higher current receptacles are simply not designed for repeated use (that's why a quality device is recommended). A properly rated adapter (in this case a 14-50 to 6-50), left in place, is (IMHO) minimally less reliable than just a plug in a receptacle. There are form factor, aesthetic and space considerations, sure. I would also cringe if an adapter and plug were exercised frequently, but I see no issue if simply left in place.