Do you ever find yourself swimming in cash and yet not the right cards in hand? This is the card you want to include then. Sometimes if steward is played early to get the right cards out the gate, you might find yourself with a ton of cash and no cards to play. This is why drinking song is so popular in this sphere.
I believe it to be unfair to say this is one of the worst cards in the game. First of all, there is no limit to X. Heck, if you have 20 lore resources you can reorder the next 20 cards of your deck. Toss duplicates near the bottom, vital cards to the top. You can combo it with vilya. You can use it for a very good tale. Or zigil miner. Or recur card draw for the next x/2 turns with expert treasure hunter. You can get timing right with thror's ring, hidden cache, or other discardable cards. In certain quests (the riddle one comes to mind) deck scrying is very important. The pure versatility of this card makes it worth it. Yes galadriel costs 3 and puts one into play -- shes a great card for sure. She also leaves play at the end of the round, so it's not a permanent boon. Also her attachment trick might whiff. So while galadriel is an excellent card, she does not set the standard for how scrying should work nor is it a perfect card to begin with.
I will say I do not play with this card often, but I could name 10 cards worse than this one right off the bat.