In order to get the standalone version, you'll want to scroll down to CurseForge download options and select CurseForge Standalone (Alpha) from the drop down menu instead - or use this direct download link. Getting to the standalone app is a little misleading however, as the link in the article directs to the main download page for the Overwolf app.

We’ve taken this into consideration and developed a standalone version of the CurseForge app on Windows, based on Electron, which you can download here. Many of the community members voiced their preference for a leaner approach to managing mods.