In my experience the red cups were used for mixed drinks being served by amateur bartenders (or jungle juice), or for kegs, or for drinking games. The latter was by far the most common - beer pong, slap/stack cup, etc. Often, people would rinse and reuse them to cut on waste and/or cost.