It comes down to one thing: whether you already shop at Walmart every week. If you do, it pays for itself in the delivery fees you stop paying. If you go to the store anyway and buy little, it is not worth it.
It works for me because there are five of us and the big grocery run does not fit into a quick trip. I order, they bring it, and I do not lose the afternoon taking three kids to the store.
There is a free trial, so the honest way to find out is this: try it for a month and see how many times you actually used it. The terms and what is included are set by Walmart and can change, so check them on their page before subscribing.