Netflix, perhaps the most prominent example, requires nothing more than its own subscription to watch on the PS4. Perhaps as a signal to how seriously Sony is taking online multiplayer ...
If your PS4 is unable to get online, you won't be able to take advantage of many of the console's most important features, like multiplayer gaming, streaming video, and installing new games.