Solved. This was one of those annoying cases where it just “started working” without a clear solution becoming known. I am going to assume it was a DNS propagation issue and for some reason Siteground’s DNS resolver was slow.
If someone else runs into this problem, my only suggestion is to wait 48 hours and try again. :-/