Infection with Naegleria fowleri is incredibly rare.

A run-of-the-mill bacterial infection is much more common. There's more than one type of infection you can give yourself by putting water into your sinuses.

You're correct that it does require a source of the pathogen, be it the water, a poorly cleaned neti pot, or the interior of your nostril.