They probably get way more reviews with the prompt, and positive ones, than without it, despite how some morally indignant outlier HN commenters would react.
Oh they absolutely work. And given that ratings are about the only thing that matters in the App Store besides search ads, there is a huge incentive to push for it no matter how horrible it is for the user.