In all of TNG, Q was a jerk, and could be indifferent to human suffering. But it was in the way that a person has no feeling for an ant that it may step on. And, moreover, Q had moments where he seemed to genuinely care about Picard and Janeway, and show compassion.
In the latest episode, this version of Q was built up to be more outright malevolent.
However...
One way I wonder as to how all of this might pivot is that maybe Picard and the crew are totally WRONG about all of it. Similar to how Picard inadvertently creates the anti-time anomaly in "All Good Things...," the corruption of the timeline to create the Confederation is all a massive time loop that's Picard's fault, and was set in motion by time-travel/multiverse shenanigans after it was induced by the Borg at the destruction of the Stargazer. We're seeing things out of order and Q's initial intervention is actually benevolent.
Maybe Renee Picard was never meant to go on this specific mission, maybe a later Europa mission, and Q may have been instrumental in helping to preserve the Federation timeline by keeping her off the launch. It would also explain the Adam Soong story. Q gives him the means to keep his daughter alive, while using him to kick Renee from the launch, and thus makes sure the Soong family line keeps going in order to make sure a future with Data and Picard happens. Maybe all of this is to reveal, just as the Prophets intervened in time to create Sisko, Q's connection with Picard was always meant to be since he made sure a future with Picard and the Federation happened in the first place.
Moreover, everything about Picard's choices has been informed by the Borg Queen (i.e., seeking out the watcher, going to 2024, etc.), and I could easily see it being that the Queen is doing a variation of First Contact and trying to undo Earth history. Picard and the crew were dumb enough to listen to her. And when Q first visits Picard in the Confederation timeline, he calls it their punishment for the choices Picard made.
In the latest episode, this version of Q was built up to be more outright malevolent.
However...
One way I wonder as to how all of this might pivot is that maybe Picard and the crew are totally WRONG about all of it. Similar to how Picard inadvertently creates the anti-time anomaly in "All Good Things...," the corruption of the timeline to create the Confederation is all a massive time loop that's Picard's fault, and was set in motion by time-travel/multiverse shenanigans after it was induced by the Borg at the destruction of the Stargazer. We're seeing things out of order and Q's initial intervention is actually benevolent.
Maybe Renee Picard was never meant to go on this specific mission, maybe a later Europa mission, and Q may have been instrumental in helping to preserve the Federation timeline by keeping her off the launch. It would also explain the Adam Soong story. Q gives him the means to keep his daughter alive, while using him to kick Renee from the launch, and thus makes sure the Soong family line keeps going in order to make sure a future with Data and Picard happens. Maybe all of this is to reveal, just as the Prophets intervened in time to create Sisko, Q's connection with Picard was always meant to be since he made sure a future with Picard and the Federation happened in the first place.
Moreover, everything about Picard's choices has been informed by the Borg Queen (i.e., seeking out the watcher, going to 2024, etc.), and I could easily see it being that the Queen is doing a variation of First Contact and trying to undo Earth history. Picard and the crew were dumb enough to listen to her. And when Q first visits Picard in the Confederation timeline, he calls it their punishment for the choices Picard made.