If you read the way tutorials pitch CQL, you will assume it's replacing SQL. But once you understand how it works, no it's not replacing SQL.

Edit: We actually use Cassandra and have found it to be an outstanding solution for our use case. But I feel like CQL's superficial similarity to SQL leads many to confusion until you dig into how it works.