Tipsy sex (with mutual and clear consent!) can be fun, but it can also be a mood killer for some.