@virgocatlover, I've been having this same conversation with my Gen Z daughter (we are watching Rivals asynchronously, for obvious reasons!).
I was a child in the 80s, so I remember when 17 was considered a suitable age for a young woman to be thinking about aspiring to an older, more "settled" man who could be a good provider. Older usually meant 20s rather than 30s, but the whole premise was that you would be looked after by a man, and you pinned your ambitions on marrying a man with a good career because if you had kids you'd probably stop working. (I didn't want that myself, but there was a definite sense that if you pinned your ambitions on yourself and your own career first, you were a horrible feminist bitch - the Cameron of the books fits that trope pretty clearly).
RCB's appeal is a bit lost on the Gen Zs because they just see an older jerk who groped Taggie. Women my age who have long fancied RCB see a handsome, suave, famous, rich, well-connected and (crucially reformable) rake. The whole Taggie storyline is Cinderella-ish, and Taggie basically reforms Rupert by the sheer power of being beautiful, wholesome and good - which is a quite an old school female fantasy!
My daughter can't for the life of her see what attracts them to each other, and has come out of the whole thing thinking Cameron was more of a match for RCB, but that's generation gaps for you...