There is no "Rating Pending" demo category on Xbox Live. You're likely seeing one of:
If a demo shows "Rating Pending" on the store page, it's not downloadable yet—check back later.