The first gay rom-com to be released by a major studio, starring and written by Eichner, made just $4.8 million in its opening