The tragedy of Palm Sunday is that on the surface it looks like Jesus was finally getting the credit He deserves, and yet He was weeping. The reason for His weeping hasn’t changed. The people (at least a lot of them) weren’t really praising Him, they were praising what they wanted Him to be. They wanted a King that would free them Rome and give them power and prosperity for today. His purpose was greater. He came to give them freedom forever and eternal life. When many of those people saw He wasn’t going to give them what they wanted, Hosanna became Crucify.
Accept Him for who He is a follow Him. He is exactly who you need Him to be.