As far as I can tell, redis is focused on being an in-memory database, while rocksdb is more tuned for file storage. Rocksdb was introduced to lower the memory footprint of hived by moving the account history data out of memory to disk storage, so it was a natural choice.