The other thing is … these are time paradoxes so whatever happens creates a new universe and we will never become aware of the alternate versions.

Are you thinking Marvel-style timeline-forking? I could be wrong, but I believe it is established that time doesn’t work that way in Trek.