The S&P 500 will surf a tidal wave of government spending – but other parts of the US economy are in pain, Kevin O’Leary says