From the Red Rock Canyon website:

Red spots in the Aztec Sandstone are iron concretions, where subsurface water has precipitated iron oxide around a nucleus in the sandstone. These concretions are more resistant to erosion than the surrounding sandstone, and weather into little balls known as Indian or Moqui Marbles.