Are nose piercing scars very noticeable?

It depends. If the piercing has migrated or had an advanced infection, then there can be significant scarring. If the piercing healed smoothly and has never had a problem, the scarring should be slim, like a tiny dot.