No, there is no auto-translation included, sorry, and you need to use 3rd party modules to get this done, please check out the links I stated before. You can see a working example at www.deutschnetnuke.de.
A language pack as described in the localization whitepaper, only contains the static elements of the framework like Button texts, Field captions and Help texts. The language editor can be used to adopt this to your specific needs, but it is not intended for content translation.