i have a requirement where i have to connect to sharepoint and download files from it without azure acct
If downloading files is the only requirement then you can map the one drive as network drive & use it as any shared drive. Also you need to sync sharepoint site with one drive.
How to map OneDrive as Network Drive in Windows 11/10 (thewindowsclub.com)
Hope this helps 