Rose itself is obviously a very old classic flower name which had its peak in the Victorian era but its use has a middle name seems to have only became ubiquitous in the last 25 years or so.
I was born in the 70s and in my generation most of our middle names were something along the lines of Ann, Elizabeth, Jane, Lynn. The rose middle name trend seems relatively newer to me.
I worked as a midwife in the early 2000s from 2001-2005 and I can’t even tell you how many parents chose “Emily Rose” and other popular names with Rose.
I’m not actually sure if it’s chosen as much any more because mae and grace seem to be getting a lot more common too and I may be wrong but I feel like the rose middle name trend was never popular before the 90s.
There will be a few exceptions obviously, I’m sure there were some considering rose is an old name but possibly just not as many as there have been the past 2 decades.