Yes, CGI is an interface of sorts.
Actually it's protocol used by Web Servers to communicate with processes that the Web Server creates, which allows the Web Server to pass information to the process and with which the process can pass information back to the Web Server.
As AmhedF said, Perl was initally very popular for creating CGI programs, and that has led to the confusion that Perl and CGI are the same thing, when in fact they are very different.
Perl can be used to create CGI programs (programs that understand the CGI protocol), but it can also be used for a multitude of other programming tasks as well, most commonly Unix scripting and system admin.
But you can create CGI programs in any language that can utilise either Standard I/O or Shell variables (be it Unix shell or Windows cmd variables). What that means you can build CGI programs in C, C++, Perl, Java, Visual Basic, PHP, Unix Shell (bash, ksh, csh, any others), and probably many others.
Right, now lets take a step back. The Web Server gets the information to the program (in whichever language you choose) by one of two ways. It sets lots of environment variables (shell or cmd variables) which you program picks up, or it passes all the relevant information in the STDIN (standard input buffer) to your program. Then your program uses this data in whichever way it pleases, and then passes the data back to the Web Server as STDOUT (standard output buffer), using whatever equivalent of "print" the langauge uses.
Most langauges that are regularly used for CGI (perl, c, shell mainly) have very popular libraries of code which transform this input from the Web Server into some more manageable format. This is because when the data comes to the process (or program, or whatever you want to call it) the data is encrypted so that non ascii characters are put into their hex equivalents, ie. a space is %20, etc.
So a "server manager" (i assume you mean like web master, blokey that looks after the web server) doesn't ahve to do anything. The web server (if it supports cgi, many simple ones dont still) does all the hard work of knowing what programs to run based on the url you ask for, and then passes the info to that process, and gets the info back, and then passes that info back to the user (or web browser).
It's that simple
Hope that makes some sense for you.
regards,
Andy.