Rodney peaked at Number 33 in 1965 and has been on a steady decline ever since. As its popularity history indicates, this name is more fitting for someone born in the mid-twentieth century instead of the twenty-first century. It's likely this name will continue trending downward for another generation or two before it has its chance to turn back around.
There have been a number of famous Rodneys over the years, including comedian Rodney Dangerfield and musician Rodney Atkins.
If looking for a way to honor a Rodney, prospective namers might consider Roderick or Rodrigo instead.