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:
- “Local” - hopefully this is clear. Local means “nearby” in a topological sense, i.e for every point there is an open neighborhood such that … In this case of submersions, you’re saying for every point there exist local charts such that your map has such and such properties.
- “Normal form” - this just means a “ has a typical format of” or “resembles the standard type…”. It’s just a manner of speaking in math. For example, consider the map $T:\Bbb{R}^n\to\Bbb{R}^m$, $T(r^1,\dots, r^n)=(r^1,\dots, r^k,0,\dots 0)$. We often refer to this linear map $T$ as the standard rank $r$ map. Why? Because it is clearly a linear map which has rank $r$, and it is very easy to write down. In your situation, they’re saying that if you have a submersion $f$, then after composing with diffeomorphisms on the domain and target, you can make that triple composition be equal to (a restriction of) $T$. i.e after appropriate compositions, every submersion is equal to $T$.
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.