Is it normal to cry over fictional characters, but not real people?

You mean like strangers you see on the news or people you actually know and are close to you?

Sounds like you have a bit of trouble connecting with real people and not stylised or idealised fictional people. Real people come with flaws and such, while fictional characters while sometimes flawed also represent archetypes which resonate with consumers of the media in question.

Probably because most real people are disgusting and their deaths warrant celebration instead of grief.

Yes very normal! I feel the same way! I have also wondered this as some I get so invested in and I feel I care about them more than people in reality !