The Rodeo can by a great dive, especially when conditions are good. I dove the Rodeo on September 22nd and there was not a drop of current and the water was a rich beautiful blue, but as previously mentioned on this thread, that's not always the case.
To safely dive at deeper depths, one definitely needs to acquire some additional knowledge, skills and experience. So many things need to be taken into consideration when diving deeper, such as buoyancy considerations upon ascent, no decompression limits, potential emergency decompression procedures, potential equipment failure, etc. And on thop of all that, one is usually not exactly clear headed because of the narcosis. And trust me, when something goes wrong and anxiety levels climb, the norcosis induced perceptual norrowing only gets more intence, which is why basic skills need to be second nature when diving deepe, because there is usually limited time to solve problems.
I am certainly not aware of your actual experience level, so I'm not saying you shouldn't do the dive, but make sure you are realistic with your skill level before hand. Also, most dive boats require either an advanced certification or proof of recent deeper dives before allowing someone to dive at that depth.
In summary, make sure you are within your comfort level. If not, seek an advanced certification or at the very least, buddy up with someone more advanced and carefully discuss the details of the dive plan and what to realistically expect, prior to attempting the dive.
Good luck and safe diving!