Zardnaar
Legend
That Force storm thing is from Legends. One of the Palpatine clones did it in a novel or comic IIRC.
In the movie, he does it after sucking up Ben's and Rey's life force. That might have let him do an empowered Force lightning. Or maybe "all of the Sith" helped him out.
I can see how projecting yourself halfway across the galaxy could prove fatal in comparison, though.
It was dumb in legends as well.
When you turn the force up to 11 it makes it hard to tell future stories.
If you use the force to blow up a fleet where do you go from there? Planet, star, system etc.