A static site sounds much worse than it is. It is simply a site with no backend or server side code. It means, once you load the web page, all the functionality comes with it. You won’t be able to communicate with a server. Static sites are usually built with HTML, CSS and JavaScript.
The opposite to a static site is usually called a web application. Amazing websites have been built with both methods, whichever you choose depends on your needs.