No, your security system doesn't technically need Wi-Fi. This even includes some wireless systems, as some have built-in networks for their security system.
However, an internet connection plus a smart home security system or a hardline connection are needed to view the cameras offsite.