How can I get $wpdb to show MySQL warnings?

From quick look through the source it doesn’t seem like wpdb actively implements any handling for warnings (as opposed to errors).

Proactively you can just ask for them as a custom query ($wpdb->get_results( 'SHOW WARNINGS;' ) I suppose, but implicitly they just aren’t tracked by WP core.