You are absolutely right that there are not enough people or DBA to understand data warehouse.

However, do you think there are enough people to fully understand SQL, T-SQL, DTS and even enough people quality to be a SQL Server DBA?

There are SQL deverlopers who do not understand what outer join is, there are developers who do not know the difference between truncate table and delete table, or IN/NOT IN vs EXISTS/NOT EXISTS.  Some had no idea what a correlated subquery is.

It is a matter of people willing to learn.  The technology is going too fast whether you are ready or not.

I consider SQL Server is quite capable of building a data warehouse. 

When I was at college, one of professor said if the program was wrong, it was not the fault of the computer, it was the fault of the programmer who wrote it.