Do stories go live as soon as my supporters submit them?

No, you as the nonprofit has to approve the profile first. However, the supporter can share it to their social media before it is approved.