That's why Pinkie Pie is beloved, even by guys. She's like the kid friendly, non-murderous, female version of Deadpool.
I'm tired of the all men are Homer Simpson, all women are Wonder Woman thing. Being goofy, wacky, or extremely light hearted isn't a sign of weakness or a horrible personality flaw. Look at Ariel from the Little Mermaid. She was a little goofy and quirky and had an adorable personality. Now look at Belle. She's pretty much stuck up and feels she's better than everyone else. That's a personality flaw. And worse, Gaston, the "villain" of the piece is just as stuck up. And we're rooting for someone with the same egotistical personality flaws as the villain. She wasn't strong, she was one of the biggest jerks in a movie full of Jerks. Heck, the father and LeFou were the only likable characters in the movie.