The issue of OneDrive shared folders turning into shortcuts in File Explorer is a known issue that remains unresolved. However, based on the information gathered from the community, there is a temporary workaround for Windows:
First, log in to onedrive.live.com via a web browser. In the root directory of the folder shared with you, select any Office document, click the three dots - Open - Open in app.
In the opened Office app, click File - Home. You can see the shared file you just opened under Recent. Right-click on it and choose "Copy path to clipboard".
Open Windows Explorer, find "This PC" on the left, right-click on it and select "Add a network location". In the "Add Network Location Wizard", click Next and then click "Choose a custom network location".
Paste the copied file path into the input box and delete the file name part (for example, if the copied path is https://d.docs.live.net/****/****/ABC.xlsx, you would delete ABC.xlsx and keep the previous part).
Next, enter your OneDrive account username and password in the pop-up window, set a name for your folder, and click Next to complete the creation.
For accounts with two-factor authentication, you need to create an app password when logging in at this stepAt this point, you can directly access your shared folder from "This PC" in File Explorer. There may be some delay, but this can serve as a temporary workaround while you wait for the issue to be fixed.