Pretty sure SM wanted to do the more straight TNG sequel, but since he is known for over the top comedy he pitched it as an over the top comedy/parody of Star Trek — and then pivoted to a homage mid season 1!
On a related note, I've been rewatching Enterprise and I didn't know Seth MacFarlane made 2 cameo appearances in the series! (In two different seasons too.)