Each point on a differentiable manifold has its own tangent space. Informally, you can think of the tangent space at a point as the space of tangent vectors to the surface at that point. But this informal picture only works if the manifold is embedded in some higher dimensional space.
A more abstract and more formal point of view is that tangent space at a point $P$ of a differentiable manifold $M$ consists of the derivatives of all curves on $M$ that pass through $P$. The derivatives exist because each map between $M$ and a chart is differentiable and invertible. So we can map a curve on $M$ to a chart, carry out calculus in the chart and "lift" the result back to $M$. The result is independent of the choice of chart, so it is a property of $M$ itself (at $P$).
It is not entirely obvious that we can create a vector space from the derivatives of the curves through $P$, but we can because the derivative is a linear operator. This vector space is then the tangent space at $P$, which we denote by $T_P$. The set of tangent spaces $T_P$ for all points $P$ on $M$ forms a vector bundle over $M$.
The answer to your question is yes but, at least according to most treatments I know, you don't really need to know the answer to make sense of the definition of the local index. This is because the authors likely refer to the concept of "orientation-preserving" isomorphisms of oriented vector spaces from algebra rather than the "orientation-preserving" for diffeomorphisms of manifolds from geometry. The latter definition involves smoothness while the former definition doesn't. As it turns out $D_qf$ is orientation-preserving as a vector space isomorphism if and only if $D_qf$ is orientation-preserving as a diffeomorphism of manifolds, but you need an interpretation of how a vector space becomes a manifold.
To make your argument precise, the first question you need to ask yourself is how do you want to think of $T_qN$ (and $T_pM$) as a manifold? That is, what is the topology and the smooth structure on $T_qN$? Without answering this question, you can't really argue that $D_qf$ is a homeomorphism/diffeomorphism. There are at least two choices which make sense:
- Think of $T_qN$ as a vector space. Any vector space $V$ has a unique smooth structure which is obtained by declaring some isomorphism $\psi \colon \mathbb{R}^n \rightarrow V$ to be a global chart for $V$. You can check that the smooth structure doesn't depend on the choice of the isomorphism and, once you use one isomorphism, any other isomorphism will also be a global chart. If you endow two vector spaces $V,W$ with the natural smooth structures described above, you can check that any linear map $S \colon V \rightarrow W$ will automatically be smooth (in particular, continuous). Hence, if $S$ is bijective, it will be a diffeomorphism (as $S^{-1}$ is also linear, hence smooth). You can also use the fact that the differential of $S$ can be identified with $S$ itself, but it just complicates the argument. In particular, if you apply this argument to $V = T_qN, W = T_pM$ and $S = D_qf$, you'll get that $D_qf$ is a diffeomorphism.
- Think of $T_qN$ as a submanifold of the tangent bundle $TN$. One can check that $T_qN$ is indeed an embedded submanifold of $TM$ so it has a natural unique smooth structure compatible with the subspace topology, which, as it happens, turns out to be the same structure you would get if you used the vector space structure. With this interpretation, you can check that $D_qf$ is a diffeomorphism by using slice charts around $T_qN$ and $T_pM$ (which come from the construction of charts on $TN,TM$) and verifying that, in local coordinates, $D_qf$ is linear bijective map, hence a diffeomorphism. You can also argue in various other ways.
Next, in order to make sense of your interpretation, note that it is not enough to give $T_qN$ the structure of a manifold. You need to orient it as well. How you will do that depends on your definition of orientation (as there are many equivalent definitions). If an orientation is defined by giving an oriented atlas, the easiest thing to do is to work with the first interpretation above. If $X \colon U \rightarrow N$ is an oriented chart around $q$ with $X(a) = q$, define an oriented smooth structure on $T_qN$ by declaring the differential $DX|_a \colon T_a(\mathbb{R}^n) \rightarrow T_qN$ to be an oriented chart (where you identify $T_a(\mathbb{R}^n)$ with $\mathbb{R}^n$ in the usual way). If your definition of orientation is different, you might need to do something different.
As you can see, there are many details to fill in order to work with your interpretation. However, most books I know (I haven't checked Tu nor Marsden) also discuss the notion of an orientation of a vector space which is a pure linear algebra notion unrelated to any issues of smoothness. Then one defines when a map between oriented vector spaces is orientation preserving and finally, one shows that the definition of orientation on a manifold $N$ induces an orientation for each tangent space $T_qN$ (which "varies smoothly" with respect to $q$). Then, the definition of index is with respect to the notion of orientation preserving/reversing linear maps between oriented vectors spaces and not diffeomorphisms between oriented manifolds. This gives a conceptually cleaner treatment as it seperates the issue of smoothness from the issue of being orientation preserving/reversing.
Best Answer
If $f : L \to M$ is a smooth map, then for every $p \in L$ we have a corresponding linear map $df_p : T_pL \to T_pM$, where $df_p(X_p)\alpha = X_p(\alpha\circ f)$. Furthermore, we have the following properties:
It follows that if $f$ is a diffeomorphism $M \to M$, then $df_p$ is an isomorphism $T_pM \to T_{f(p)}M$.
Now if $(U, \varphi)$ is a coordinate chart on $M$, then $\varphi$ is a diffeomorphism $U \to \varphi(U)$ where $\varphi(U)$ is an open subset of $\mathbb{R}^n$. Therefore $d\varphi_p : T_pU \to T_{\varphi(p)}\varphi(U)$ is an isomorphism so
$$T_pU \cong T_{\varphi(p)}\varphi(U) \cong T_{\varphi(p)}\mathbb{R}^n \cong \mathbb{R}^n.$$
In addition to the pointwise isomorphism of tangent spaces, we get a vector bundle isomorphism $d\varphi : TM|_U \to T\varphi(U)$. In particular, as $T\varphi(U) \cong \varphi(U)\times \mathbb{R}^n$, the tangent bundle to $M$, when restricted to a coordinate chart, is trivial. That is, the tangent bundle is trivialised by coordinate charts.