Hd is the future, but Sd will be around for a number of years yet, and Sd is NOT just for home video sharing with your freinds and posting on the web
Buy the best camera you can afford and learn how to use it, the best Hd camera in the world will not produce better footage than the guy/gal running it.