Don't just assume all-seasons are "good enough" because they're marketed as a compromise solution. The thing is, all-seasons are actually a compromise in both directions - they're okay at summer driving and okay at winter driving, but they're genuinely mediocre at both compared to purpose-built tires. In moderate snow like what you're dealing with, dedicated winter tires will stop significantly shorter on ice and snow, grip way better on cold pavement, and handle acceleration and cornering more predictably. The rubber compound in winter tires stays flexible in cold temps, while all-seasons harden up, which tanks your traction. Summer tires obviously aren't relevant for your situation, but the point is you're sacrificing real safety by splitting the difference.
That said, separate sets make the most sense if you actually experience multiple months of winter weather. For your CR-V with decent but not extreme snow, you're looking at maybe October through March where winter tires meaningfully matter. The upfront cost is real - you're buying two full sets plus potentially paying for storage - but winter tires last longer when they're only used seasonally, so you're not replacing them every couple years. Most people find it's worth the investment once you factor in the safety difference and the longevity math. You'd swap them out twice a year, which is annoying but takes a couple hours at a shop.
If you're genuinely on the fence, check what kind of snow you actually get. If it's light and infrequent, all-seasons might suffice. But if you're dealing with regular accumulation and icy conditions, winter tires are worth the hassle. A lot of folks in your climate zone go the separate set route and don't regret it.