It's canon so y'all are going to have to suck it up.
That doesn't really make any difference to me. I know terrible writing when I see it.
Voyager's Q might have been a "pathetic loser", but TNG's Q wasn't. They are different television shows with different artistic visions and different people working on them, so it's worth pointing out these inconsistencies, regardless of canon status.