The billionaire hedge-fund manager told CNBC it takes two years for the impact of rate rises to kick in, warning the US will soon feel the pain.