Solution
NI-VISA binaries for M2 chip are intel based, they run under Rosetta, which is dynamic binary translator, to allow apps built for Intel chips, to run under Apple Silicon chips.
Therefore, to solve the issue, please make sure Rosetta is installed in the MacOS.