The large bloated size is probably due to the Software Store trying to install a Snap or Flatpak package.
Zorin OS offered something new in Zorin OS 16- the ability to click a `Sources~ button on the Headerbar of the software store and see the sources available.
Failing that, you can just navigate to the installation page of that program in Software Store and scroll down to "sources" and read it there.
Snap and Flatpaks both operate on the notion of "Bring everything including the kitchen sink" - all dependencies and extra packages that may be needed for that piece of software.
In installed VS code on my machine many months ago and it was around the 200 mb's you cite. I did not install from Software Store (and I do not install anything from the Software Store...)