I am studying manifolds from Tu's text on the subject, and he uses the term normal form but I do not recall seeing this term formally defined. The closest I've seen to a definition is Tu's statement of the constant rank theorem:
Let $N$ and $M$ be manifolds of dimension $n$ and $m$ respectively. Suppose $f: N \rightarrow M$ has a constant rank $k$ in a neighborhood of a point $p$ in $N$. Then there are charts $(U, \phi)$ centered at $p$ in $N$ and $(V, \psi)$ centered at $f(p)$ in $M$ such that for $(r^1, \ldots, r^n)$ in $\phi(U)$, $$(\psi \circ f \circ \phi^{-1})(r^1, \ldots, r^n) = (r^1, \ldots, r^k, 0, \ldots, 0). \tag{1}$$
When talking about local normal forms he references (1), so I am guessing that this is the formal definition. Likewise the Wiki on submersions has a section on local normal forms but does not formally define it.
What is the local normal form exactly and why do we care about it?
It’s not a technically defined term (well I guess one could define it technically, but there’s not much point to it). It’s just one of those things which people start saying once they know what they’re talking about. But let me try to illustrate the meaning:
In linear algebra you’ll see many more examples. For example, you may have heard of Jordan canonical/normal form or rational canonical form. What do these terms mean? It means under appropriate hypotheses, given a linear map $T:V\to W$, there exist bases $\beta,\gamma$ on the domain and target respectively such that the matrix representation $[T]_{\beta}^{\gamma}$ has such and such simple entries (e.g. some number of Jordan blocks).
Another example: in symplectic geometry, the things of study are $(M,\omega)$, where $M$ is a smooth manifold, and $\omega$ is a $2$-form on $M$ satisfying certain conditions (closed, and non-degenerate), known as the symplectic form. The standard and simplest example is $(\Bbb{R}^{2n},\omega_0)$, where we label the Cartesian coordinates as $(q^1,\dots, q^n,p_1,\dots, p_n)$, and define \begin{align} \omega_0=\pm\sum_{i=1}^ndq^i\wedge dp_i; \end{align} sign conventions are a nightmare so just ignore that. Now, it is a wonderful theorem of Darboux that for any symplectic manifold $(M,\omega)$, and for any $x\in M$, there is a chart $(U,\phi=(q^1,\dots, q^n,p_1,\dots, p_n))$ around the point $x$ such that on $U$, we have $\omega=\pm\sum_{i=1}^ndq^i\wedge dp_i$. Said diffferently, $\omega=\phi^*\omega_0$. So, around every point, there’s a chart such that the chart makes the abstract symplectic form $\omega$ look like the plain old vanilla symplectic form $\omega_0$.
So you see the recurring idea: you start with some simple object which you understand very well (e.g. a linear map of rank $r$, or a Jordan block, or a diagonal matrix, or the identity map or whatever). Then you take a look at your new complicated object (could be a random linear map, or a submersion, or a local diffeomorphism, a tensor field, a differential form etc etc), and then you say ok, this object I have is complicated, but after some finessing, I can make it look like the simpler object. You can certainly try to formalize this notion using equivalence classes and stuff, but hopefully the idea is clear.