Built from
红颜 ('red face' = young beautiful woman) +
祸水 ('disaster water' = source of calamity). Traditional historiography pinned dynastic collapses on women -
妲己 for the Shang,
褒姒 for Western Zhou,
杨贵妃 for Tang. Modern usage is often ironic or critical of that framing.