Comparing SQL Server to SQL Azure is like comparing traditional C++/C# forms to ASP.NET. There are some applications where moving to SQL Azure is an evolutionary leap, but there still be plenty of applications where sticking with SQL Server is the best choice, not only for existing implementations but also new developmet going forward.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho