Can you have a great marriage without great sex? How about no sex?

A great marriage - but possibly a short-lived one. Physical intimacy and procreating are two of the most beautiful things a couple can share. Possible, yes, anything's possible (depends on the personalities, priorities, and values of the couple), but it's definitely not for most.