This summary is not the rule. The rule text controls.
When someone tries to use a deposition as evidence at trial, the other side can still object to it. The rule says you can challenge any part of a deposition for the same reasons you could challenge a witness who was actually there testifying in person. In other words, being in a deposition doesn't give testimony special protection from objections.
This matters because depositions are taken before trial, often months or years earlier. Just because someone answered a question in a deposition doesn't mean that answer can automatically be used later. If the testimony would be objectionable coming from a live witness (like if it's hearsay, irrelevant, or based on speculation), it's just as objectionable when read from deposition transcripts or shown on video.
There are two exceptions written into this rule. It points to Rule 28.02 and Rule 32.04(3), which cover specific situations where different rules apply. Outside of those exceptions, the normal rules of evidence still control what parts of a deposition can come into a trial or hearing.