A bit of extra clearence and AWD might make you more comfy, but are probably not needed. There are many trails and therefore many trailheads with a variety of road types leading to them. Most of the roads in Rocky Mountain National Park can be traveled by ordinary passenger cars, at least when it's not snowy.