In most cases, it affects the website because of the downtime. After you transfer a domain to a new register, it loses the past Nameservers and other DNS records. And replaced by the new DNS according to the new register. As a result, you many need to replace the Nameservers and make changes to the other DNS records. Since the propagation takes time, your website will be down during this time.