SmartAsset landed $110 million in a Series D funding round that pushed the firm's valuation over $1 billion. But not all advisors find the service to be useful.