This happens because no row is inserted into SDE.ST_GEOMETRY_INDEX if there is a preexisting row for the same feature class name in SDE.ST_GEOMETRY_COLUMNS.Use sde.st_geom_cols_util.delete_gcol to delete the metadata for the table in SDE.ST_GEOMETRY_COLUMNS before creating the spatial index.