It is the utmost in disrespect.
Well maybe in the crudety in how it is said. But it means what it means and yes, most women deep down would be flattered younger guys still find them attractive to think that.
"Cougar"