A residential rotating proxy provides IP addresses assigned to residential devices, and they rotate periodically to mimic genuine user behavior. They aid in CAPTCHA avoidance during web scraping by distributing requests across multiple IP addresses, making it harder for websites to detect and block bot activity.