Cannot enqueue jQuery correctly using Google CDN

It’s very likely that your test is broken because of conflicts. You are essentially loading two versions of all your UI scripts. That is because the Google CDN version of JQuery UI is not the core, but the entire script library (including datepicker, autocomplete, etc), as opposed to the WordPress scripts, which are broken into pieces which tend to be concatenated when inside the admin area.

This means that you don’t have to enqueue all UI scripts separately, if you’re including Google’s version. They’ll just work. Try that first.

If you find that something else (WP, a plug-in, an element from your theme) is enqueuing WP’s default scripts and causing trouble, you can try to dequeue the ones which are causing conflicts (just look at the bottom of your test page: they’re all there). Or you can try the official way to replace WP scripts with CDN ones, as stated in the Codex.

// Deregister first, then register again with new source, and enqueue
wp_deregister_script('jquery-ui-core');
wp_register_script('jquery-ui-core', 'http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.12/jquery-ui.min.js');
wp_enqueue_script('jquery-ui-core');

The problem here are dependencies. You might have to do this with other UI scripts in order to make it work as expected.

Last but not least, I hear WP 3.5 has the latest versions of UI included by default (1.8.23 as of today). While I can’t say that you won’t have other problems if you use the 3.5-alpha available today, you’ll probably be safe from script enqueueing conflicts.