It looks terrible to me and absolutely destroy the image. I already have to deal with that in real life because of glasses (I'm nearsighted), having another layer of chromatic aberration added to my games is something I can't tolerate.
It gives headaches, it looks terrible, it's uncomfortable to look at, and it's there for stupid reasons, just trying to mimic films.
Also something I never understood is that people who defend chromatic aberration often say things like "it's barely noticeable", "you won't even see it", but then "it adds to the visuals " "it adds atmosphere", if it's not noticeable, how does it improve the image? lol
I agree it's a shame I had to avoid the game "just" because of this, it's frustrating to me to skip a game just because of a dumb filter like this, but they really could have added an option to turn it off (vignette too), like most games do. When they announced the DLC, I got kind of excited because the trailer for the DLC didn't have chromatic aberration, so I was hoping that maybe they would finally add an option to remove it, but nope, it's still there in the actual game.
Yes I know about the mods, and if I do decide to play it anyway one day, I'll have to use them, and I agree with vignette too, it also looks terrible. The issue like you mentioned though is having to give up on all the online features, they are nice and always contributed to the overall atmosphere in souls games, it's sad to have to give up on them.