It's very rare if we get rain before, say, 3pm. Just go in the morning and it shouldn't be too bad. Also, since Red Rocks is right along the front range the rain will likely pass it by. Often the rain evaporates before it hits the ground here.
I am planning to drown my sorrows in Guinness...