Stagnation Pressure is analogous the amount of total energy fluid volume have in a system.
In absence of any external work feeding mechanism to this fluid volume and if losses can be neglected i.e inviscid flow, total pressure at each and every location remains constant.
Think of flow in a pump, where the impeller is doing external work on the fluid, thus increasing the total energy of the fluid parcel or total pressure.
Static pressure is analogous to potential energy of the fluid volume and dynamic pressure is similar to kinetic energy.
Consider flow in a pipe where you are also moving with the fluid velocity, you will be subjected to some force by fluid particles.
This force you is because of static pressure but if you were stationary , you will experience a higher force, that is because fluid molecules hitting you will come to stop and their dynamic pressure will be converted into static pressure, thus increasing net force on you.
If you have fluid flowing through a converging or diverging system with zero losses, the static pressure will convert into dynamic pressure keeping total pressure constant.
Now coming back to the pump example, if you were to sit on the impeller blade that is inertial frame of reference, to you impeller is not imparting any momentum to the fluid , thus total pressure in the frame of reference of the impeller remains constant if we are again to neglect losses due to viscosity or any recirculation.
Hope this helps