Is “Cancel Culture” really more complicated than “we should hold people accountable for shitty things that they have said/done in the past?” or am I missing something?

Pretty much no. There's some cyberbullying happening, but they keep mixing that shit up with canceling people for their shitty behavior, which doesn't even really mean fucking anything