[To dev/1.3] Pipe: avoid event accumulation in the stale sink pending queue & promptly clean up closed processor subtasks & close parser when releasing phantom reference of tsfile event (#14820)

[To dev/1.3] Pipe: avoid event accumulation in the stale sink pending queue & promptly clean up closed processor subtasks & close parser when releasing phantom reference of tsfile event (#14820) #14634