You are proposing CIWS as ship's only point defense. Which may work for corvettes, but sound unrealistic for frigates, which operates in high intensity environments regardless of its role.
CIWS missiles usually have only one shot at a single target in a given scenario. Which defeats the purpose...