Revert "pin dbt for test", try removing default dbt profile dir

Summary:
This reverts commit fdbcecb76c5dc483f72ffb168d3d8c0385113a30,
Implements @owen's suggestion in https://dagster.phacility.com/D8831
Completes https://github.com/dagster-io/dagster/issues/4351

Test Plan: bk

Reviewers: owen

Reviewed By: owen

Subscribers: owen

Differential Revision: https://dagster.phacility.com/D8839