This might be a little "simpler"

(CHARINDEX('.',REVERSE(ContactEmail)) > 4)

This checks for the last index of a period in an email address thats position is not more than 3 places in

meme.email@domain.ccom would "fail", but meme.email@domain.com and meme.email@domain.ca would "pass"