Success is always relative for football fans- I don't think Yeovil fans care much who are champions at present or who wins the Cup on Saturday. They are in a play-off final and can reach Championship level for the first time in their history.
I remember when Utd were ridiculed, much as Liverpool are now. People talked about the glorious history- the Busby Babes, first English European Cup winners, league titles, Best, Law & Charlton- and proclaimed the club as the biggest in the world with the biggest support, yet the team were a laughing stock.
As a kid, I went to Wembley twice in one season in 1983. I stood up on a train all the way to London for the League Cup final, stood behind one goal and saw none of the three goals, which were all scored at the other end, including Liverpool's winner in extra time. But just getting to a Wembley final and having the day out seemed fantastic! Can you imagine how most Utd fans (me included) would feel about finishing runners-up in the League Cup now? It got better when we went back in May and beat Brighton in the F.A. Cup final after a replay (I saw the mad 2-2 game), but winning that trophy felt like a monumental achievement then. Then beating Barcelona (with Maradona) 3-0 at an impossibly full OT in the CWC Q-F the next season after losing 2-0 in the away leg is still far and away my best memory- better than watching the 1999 CL final on TV.
So if Utd don't have continued success under Moyes, then we'll adapt and enjoy it all the more when success does return.