
I hope so too but I don't really have faith in it since that's what the author deems to be a cute character. If she doesn't, her selfish (or maybe it's not selfish but stupidity? Idk) disregard for the situation/others may be somewhat annoying but it's not a manga dropper as it's done in a childlike, innocent manner of not understanding the consequences of your actions.

I know how you feel. When I read the novel and saw what would happen more in the future, I felt like wthhhhhh. Author-san likes Shion so much, even taking her to the banquet, always being willful and causing ruckus while Benimaru is stuck in the city and has so much less scene. Like, he’s the Commander in chief but we don’t get to see him much. And how did Shion even manage to keep her position as a secretary when Shuna does all the secretary’s work?! (╯°Д °)╯╧╧

Ah, I think that's the thing I don't like about her character most but couldn't place it until you said this. Everyone else has worked hard to earn their position and contribute to Tempest, even the arrogant lizardman turned dragonnewt guy whose name I'm forgetting. Shion, on the other hand, they just give a free pass to literally everything. She loves Tempest just as much as everyone else but no one disciplines her for her behavior/mistakes when she tries to show that love thru her failed efforts. So she doesn't correct her behavior/makes the same mistakes again and that's frustrating to look at. I didn't even remember that she was listed as a secretary because she has no place in an office, especially when Shuna does all her work.
They can't leave her by herself and they don't teach her anything so she just comes off as a spoiled child in the body of an adult that has no purpose in the story other than being part of the big family. If they at least had her in some kind of bodyguard role (not specifically for rimuru but anyone), patrol/police force, or literally anything that uses her one talent instead, maybe it would make more sense for her character. As it stands now tho, she's just kinda... There. And you remember that she's there when she causes an embarrassing scene or caused something to go awry.
I understand that they are trying to make her seem cute by being like a child in the body of an adult but I always found it annoying. Especially whenever someone had to pick up after/fix her mistakes or whenever she was reluctantly brought along only because she was being too willful/couldn't be left on her own without supervision. She always irritated me because she wasn't a child and the things she did weren't accidents but just thoughtless.
That being said, she is a part of the family. I never liked her, but I never hated her. I especially never wanted her to die, let alone from such a cowardly method. I'm glad she's back.