I love LD and I mostly like SNW. Discovery lost me near the end of season 2 (and almost lost me several times before). As others have said, the good characters went to SNW (except for Saru).
If you want an actually good show that has similar energy to what Disco was going for, while being majorly disloyal to it’s source material (also like Disco) watch Foundation.