The CEO of Royal Bank of Canada is finally seeing that foreign inflows of money are distorting Canada's housing markets and that these types of investments are not what the country needs.