I would like to answer this from the viewpoint of someone who used to support and maintain some of these applications for FreeBSD.
Packages provided by open source system vendors tend to run a gamut from barely maintained to almost critical pieces of the system. There are differences in the way BSD variants handle their systems vs Linux as well, in Linux most of the user space tools--the shell, system startup, etc--aren't part of Linux itself, but rather packages layered on top of the Linux kernel.
Then we have packages, or ports as they are known in the BSD world. These are specific instructions to build applications from outside the core operating system, including such things as graphical workstation desktops, database and web servers, mail servers and clients, etc. The level of support for and care towards these types of applications tends to vary greatly from one package to another. Well-known packages with their own large development teams, PostgreSQL leaps to mind here, tend to be well supported, and the packages for them in open source OSen tends to be very good, with careful attention paid to security fixes from the upstream vendor.
At the other end of the spectrum are obscure packages like a SNOBOL compiler, or an ancient adventure game written in Fortran, which tend to hang out in package build directories long after their initial interest has waned, often until they will no longer build, when they are marked as broken and left as zombies.
So to fully understand the situation, you have to look at the application itself as well as the vendor/distro packaging. Is the application actively developed and maintained? Do they have a security officer, and respond to security alerts? Then we move to the distro packaging: is it kept up to date? Are security updates available for the version you intend to run? Is the package generally well maintained in the distro or vendor sources?