Hi Luv2,I'm a little surprised nobody jumped in to recommend the great collection by Ian Tyson — his "Cowboyography" series. Ian started in the early '80s to record a group of songs REAL cowboys would like; he cut the first album — Old Corrals and Sagebrush — in the living room of his ranch house in Alberta. Since then he as done five more — all pretty good, but getting progressively slicker through the series.
If you're interested particularly in songs about rodeos, there are several in the later albums. Some idealize the riders, but many recount the fear, disillusionment and longing to get out of the game that you'd expect in such a rough sport.
I highly recommend you look into the whole series. If memory serves, they are, in order:
Old Corrals & Sagebrush
Ian Tyson
Cowboyography
I Outgrew The Wagon
18 Inches of Raindavid