Because of the rainy weather, astronomers in some areas failed to enjoy the wonders of transit of venus.

Because, and is the causal relationship of table connection. ..

So only one can be kept:

Because of the rainy weather, astronomy enthusiasts in some areas failed to enjoy the wonders of transit of venus.

or

Rainy weather prevents astronomy enthusiasts in some areas from enjoying the wonders of transit of venus.