I would like to know if they knew they where about to drop a bomb killing thousands, or they where simply given a simple bombing mission.
I believe they knew. Here is a quote from the Pilot Colonel Tibbets: "When the bomb is dropped, Beser [the radio officer] will record your reactions. This record is for history, so watch your language."
Source: Hiroshima by Stephen Hoare. Probably in plenty of other places too, but that's where I read it.
Here are some other reasons I think they must have known (I can't remember where I learnt these, but it is likely to be the same book, or Hell in the Pacific by Jonathan Lewis & Ben Steele):
P.S. I expect someone better informed than myself is going to be able to tell you more directly, where I have only been able to speculate.
edit: clarity
The unit that flew the aircraft, the 509th Composite Group was specifically formed to train and develop methods for dropping atomic bombs. The aircraft were specially modified to carry the uniquely shaped bombs.
Col Tibbets was the 509th's commander and had been training with the unit since Dec. of 1944, and then was the pilot on the Hiroshima mission.