Do I need to be connected to the internet for anything?

An internet connection is required when using multiplayer.
In addition, a PS Plus account is required for PlayStation, and a Gold account is required for Xbox.