Do I have to have a Gatsby Cloud account to see a Preview?

You will need a Gatsby Cloud account to see a preview only if the site has been set to require Gatsby Cloud authentication. See How can I make my Preview private? for more details on Access Control in Gatsby Cloud.