So to some it up: like what it names suggest, Script Extender is the program that allow you to add more script to the existing Bethesda code. With normal modfing you can modify some asset in Skyrim but with SKSE you can essetially make a new game out of Skyrim assets.