It seems like the British monarchy is stripped of almost all powers and has a purely ceremonial role. If I understand correct, they have almost no say in the government. Why is the monarchy yet around then? Wouldn't it be fairly frustrating to be a Queen when you actually have no real power? Why do people are the people yet so excited about the Queen?
Just as a friendly suggestion, you may want to direct this question to /r/asksocialscience too. Whilst there's a lot to be said for the history here and hopefully someone well versed in the literature can offer you a strong answer, you seem very interested in the situation today in the UK, and that is a question political scientists or legal experts are better placed to address (not least because this sub-reddit is only permitted to deal with matters at least 20 years old) given the intricate complexities of the UK's ever-changing, malleable constitutional order.
Just fyi, you'll find some background info on the role of the British monarch in the FAQ
symbolic, officially the queen has some power such as the power to declare war. 1 reason she's kept around is because brings in more money than she spends, through tourism cgp grey did a good vid on this https://www.youtube.com/watch?v=bhyYgnhhKFw