The CLT is definitely profound and extremely useful. It encapsulates the heart of many fundamental theorems in mathematics in its ability to connect so many different results in statistics. It's also a nice result to have when co-workers dispute your analyses, and you have a handful of statistical tests that back you up (you can't argue with mathematical proof when you have many observations to rely upon!)