Perhaps it isn't that science is unprofitable, it just isn't immediately profitable.

Pretty much the entire modern economy, i.e. those parts that don't depend primarily on manual labor, politicking or usury, is founded on the work of scientists and engineers.