If you're going to ride, then get a small waterproof point and shoot, and make do with whatever photos you get out of it (which will likely be just fine).

If you're going for the purpose of taking pictures, then take the DSLR, lenses, tripod, whatever, and deal with the bulk and weight.

If you buy a new camera, try it out plenty before you go.