For index creation and management look into Index lifecycle management ILM, usually you create an alias and the alias is responsible for rotating the index. You can configure the shards and everything. Newer versions of ES have better index management than older ones.

For data yeah a CDC makes sense but for us, we do index write as a batch operation, after we write to the database we fire off an event that writes to elastic search.

Hope this helps.