RocksDB requires cross address spaces RPC calls which, naturally, is going to be a lot slower than doing something in-process in a streaming engine.
I think most teams who implemented stateful streaming engines just wanted to get to market quick, like the Flink team I knew, hence they chose RocksDB.