What's the real trade-off CQRS introduces once the read model lives in a separate data store?

The read side becomes eventually consistent with the write side — the moment a command commits, the write side is immediately consistent, but the read model only updates once its triggering event has propagated and been processed, a real non-zero delay that needs to be a deliberate, communicated trade-off.