ahh it's finally, definitely, confirmed-ly released this time, on the web this morning at 10am. I remember we made the announcement in December but then retracted as something happened internally that stopped the team from being able to release it together with Visual Studio 2005 sp1.
Here's how you get the downloads:
This package will install the SQL Server 2005 Compact Edition runtime engine on your desktop.
Download the package containing the files required for installing SQL Server 2005 Compact Edition developer SDK runtime components. Use these components to rapidly develop, test, and deploy applications on mobile devices. The SDK also contains the header files for developing applications based on mobile devices.