Not really. It's shiny. It's like a real life ding/chievo/whatever you call them these days.
It's important enough that you can write it on like headed notepaper without seeming like a complete jerk. If I see somebody sent me a letter from "A Smith CBE" that seems reasonable I guess they have a CBE, how about that - if they write "A Smith BA(Hons)" I know they're a terrible person - who cares that you have a fucking undergraduate degree? Am I supposed to be impressed?
One more notch up makes you a knight. So, if you're collecting and this is early in your career that's a good sign you could get there. For example when I was a research student 20+ years ago, my Head of Department was looking to get herself some Honours, and these days she's Dame Wendy.
But like, it doesn't come with a heap of money or anything as far as I know. You briefly get to meet Charlie I guess, but I met his previous wife once (when I was a kid) and she was just some woman, so I doubt he's any different.