Yeah, it's probably a bit overwhelming if you're not involved in development, tech, etc., I've been doing this for 25+ years, in various capacities.
This might help a little, or make it much worse ...
Let's just talk browsers. So you've got this application running on your desktop, let's say Chrome.
You enter an address, some magic happens with networks and routers and data is fetched from some machine. That data can be - what is basically plain text files - the server reads the requested file and send it over the network to your browser. If the content (to keep things simple) is HTML it parsed the data and displays a web page, you know, text, images, in different positions, and size. That plain text file can also have Javascript code in it, again, the browser reads this code and executes it, right in the browser - it's not unlike you downloading an app and running it from your desktop.
Now, here's the server / backend part: when the request is made from the browser, sometimes the page isn't a simple text (html) file just sitting on the server, it's a file that's been coded in a server side language, and it "runs", this can be things like the server fetching data from a database. Then the server, on the fly (dynamically) puts the data into a format defined by the programming language, builds the "page" partially from a template, in memory, and sends that over the network.
So think about when you search for products on Amazon. There's some parts of the page that are static like the Amazon logo in the top left, other parts like the product listings aren't in that template file, the server reads the template, fetches the data, then creates a new version of the page combining the static template with the dynamic data, which is what you see.
So opening a purely static file/files, with HTML, and/or Javascript, doesn't require a server, just the browser opening the file, though it is often sent over a network _by_ a server. If the file is just a template, that loads in dynamic data that's served by, for example, a database server, then it requires a server to process the request, load the template, fetch the data, build the resulting response, and send it over the network to your browser.
Clear as mud?