NSO is not the best service, but it's fairly cheap (it becomes dirt cheap when you are on a Family plan) and offers enough to become a really good deal. To put into my perspective, I pay the equivalent of USD 12 per year and I have access to online features for all games, the Happy Home Paradise (USD 27), lots of retro games, the 99-style games, soon the new MK8DX courses (USD 27) and sometimes, access to full games like Captain Toad (USD 50). While I'd loved online to keep being free, I understand the world we're living in, so not too fussed about it. However, even if it's cheap, it's not something everyone can afford, so in that sense, it sucks.
For Animal Crossing New Horizons specifically, I think they did a nice job of limiting the things people "miss" if they are not able to pay for NSO. There's less items locked behind trading than NL, and even then, since there's free trials, items are a complete non-issue. Dreams, while cool to do by yourself, can be "replaced" by the way social media works. With minigames being exclusive to NL, visiting each other kind of defaults back to pre-NL era and tons of people already say there's no reason to visit each other so yeah. The only thing that is potentially bad is the custom designs portal, since many people aren't as talented as others, but again, you could potentially download 100 designs on a free trial and be set for life (unless your playstyle involves changing designs every other day- and this is only a true problem if you indeed rely on custom designs, not all people use this feature since it's not obligatory or essential). Oh and the backup feature, which is a bit of a mess by itself. The Nook Link is very, very nice and I love the newspaper, but I don't think it's essential or anything.
I do think the narrative some people keep spreading about how NH is somehow more dependant on online than its predecessors isn't helpful (or completely true), but people like to do that ¯\_(ツ)_/¯
Having to pay sucks, but I also understand how business works so I can't think of a better solution.