Use localhost "Desktop App" flow by default

[tswast]

run_console will stop working this year.

https://github.com/googleapis/python-bigquery/pull/1147

https://developers.googleblog.com/2022/02/making-oauth-flows-safer.html?m=1#disallowed-oob

See also: #54 to provide and alternative and #48 to cover a safer alternative for cross-cloud use cases.