In Charli's latest Substack, the Brat artist muses on the "realities of being a pop star," according to her