Tell that to the writers of Discovery season 2. They tried so hard to bring "canon" in "sync" that they had to leave 23rd century completely behind. And they used exactly "convoluted fankwanky explanations" to do it.
Yes, I’m aware of that. And no, they absolutely did not need to do any of that. If they really couldn’t find a way to bring ‘canon’ in ‘sync,’ all they had to do was admit that DSC takes place in yet another alternate universe from the prime one and continue on with their version of the 23rd century.