I've never been a fan. I find it sickly sweet cutesy, in the same style as Poppy, Tilly, Maisie, Gracie. They're all very twee.
I always think "what if she's not so Bonny?". It's a bit like the trend for using Belle as a given name. It's not for me.
I have to agree though that, sadly for those who do like it, the name is now strongly linked with that vile woman Bonnie Blue. It climbed as high as 16th in the 2024 stats but, with Bonnie Blue becoming a well known name for all the wrong reasons right at the start of this year, I can see it easily dropping 20 or more places in the 2025 stats. Surely nobody wants their daughter associated with her? A bit like how it briefly became quite a thing in the 90s for people to use Jordan for a girl, then it dropped like a stone when Katie Price coined the name 'Jordan' for her Page 3 career. I can see Bonnie bombing in the same way.
Edit - I've just looked it up, and Jordan was hovering around the 70th to 90th position for girls in the late 90s. Then in 2002, it dropped to 215th from 95th the previous year. That's a drop of 120 places in just one year! Guess when Katie Price started really disgracing herself?! It shows the major effect scummy celebrities can have on a name's popularity, despite some claiming it doesn't matter. To many people, it really does matter if a name suddenly becomes associated with something or someone terrible.
You also only have to look at the drop in the usage of the name Madeleine after Madeleine McCann disappeared in 2007. People no longer wanted to choose a name so strongly associated with sadness (as beautiful as the name is). Axel was a name really in the rise at the start of this decade. It slipped right down last year, after the atrocities in Southport. Association matters to people.