For example, look at the original Star Trek. The effects were very unrealistic, everyone knew they filmed planet scenes in the desert (not on a different planet), etc. But nobody cared, it’s still a cult classic.
Star Trek TNG is pretty much the same. Despite more advanced effects, everyone knows Data is just a guy with makeup, but it was much harder to think the Enterprise was not a real ship.
At the end of the day, suspension of belief depends on delivery of lines, acting, etc, and much less on CGI or “classic” effects. CGI just makes (arguably) easier to achieve the effects.