It's not exactly with sin, but sexual activity is correlated with the power of creation. So "misusing" a "big bang" is often painted as something "bad", be it a sin or simply considered an act of layman's ignorance.