For anyone wondering, yes it is exactly that bird sound you are thinking of:

www.allaboutbirds.org/guide/Common_Loon/sounds