The ionized gas in nearby galaxies as traced by the [N ii] 122 and 205 μm transitions