Mel, I see you already got pretty good answers from others and just I add a few things here:

Why VS Code? https://code.visualstudio.com/docs/editor/whyvscode
It's light, fast, free, simple, customizable, reliable, available on Windows, macOs, and Linux, with huge available extensions (as it comes with public extensibility model).

VS Code introductory videos:
https://code.visualstudio.com/docs/getstarted/introvideos

VS Code programming languages:
https://code.visualstudio.com/docs/languages/overview

VS Code tips and Tricks:
https://code.visualstudio.com/docs/getstarted/tips-and-tricks

VS code is file and folder based and Visual Studio is more project and solution based.
VS code is an editor and beyond that, it supports Intellisense, debugging, source controls (e.g. Git, ...) and more.

Of course there are alternatives for VS code too such as Atom, Sublime and more.

About the usage better to say "it depends", if I go for a .Net core project then my choice is Visual Studio but I definitely prefer to use VS Code in my windows and mac book machines for Typescript, Javascript, Node.js google cloud functions, Angular, ionic and debugging those codes - absolutely not with Visual Foxpro.