How to handle overly aggressive Characters ?

I’m fairly new to D&D, and I also DM a campaign with a bunch of my close friends and even siblings. I completely understand why you would want to be delicate about this- I do, too. Maybe there is a way to be kind about it, but still firm. 

“Hey, guys. Recently, I’ve been struggling with DMing a lot because I feel like the plot is stunted when you guys kill my NPCs. Would it be okay if you could tone it down, so we could have a lighthearted game?”

They may not listen, so that’s when you may want to consider in-game consequences. Maybe have a bounty put on their head. A bounty hunter could hear about them, for example, and chase after them, sort of like the Mandolorian. This could put pressure on the character to change their alignment, and I would suggest talking to them one on one about the possibility of that.

If they still don’t listen, start small by removing them from one session. Be kind about it, of course, but real friends should be a little firm with each other, sometimes. If they have an issue, talk it out with them, but don’t take away the consequence. If the behavior continues, tell them you are considering removing them from the campaign. If they still don’t stop, then do so.

I know it’s hard, but a fun game between you and you’re other friends is absolutely worth it. Good luck!

FAFO.  Let the world punish them for their behaviors.  I've had a character who had to flee a major city and was hunted all across the nearby areas for his misdeeds.  I had him learn from all this and he had a nice little redemption arc. 

 Thanks, there´s some very useful suggestions.
Again: No ones fun has been ruined in our group yet. 
I don´t want to punish any of my players but steer in the right direction before things get out of hand or start becoming a problem.

Quote from Caerwyn_Glyndwr >>

I will start by saying that Rime of the Frostmaiden is a notoriously bad adventure - it has issues being directionless, has some serious pacing problems, and has a main villain who inexplicably dies with two chapters left in the campaign and who is so utterly uninteresting as written D&D Beyond once did an entire article pretty much apologizing for how bad Auril was handled in the text.

 
This also surprises me, I had the impression that Frostmaiden was actually a highly regarded campagin, and me and the group are really loving it.
Though I already have made some substantial changes to Auril and her "spell"
I also made up a simple reputation system for several factions early on and told my players that their actions would influence what these factions might do later.

But yes, I think because the players killed off most of the knights of the black sword, I´ll make that weaken the defenses of Caer-Dineval when the dragon attacks.

No, Rime of the Frostmaiden is widely regarded as one of the worst 5E modules ever made.  The tone is indecisive and swings wildly between grimdark and whimsical, the rules presented for things like the dog sleds don't actually work, most of the module is a series of unrelated side quests, and Auril herself is a severely unimpressive boss fight.