No? There are lots of online only games that don't have any way to access their content in a single player mode.
That said, this was part of Star Citizen from the beginning, and if anyone ever told you otherwise they are mistaken. The "MMO" part was actually their first stretch goal, it was a single player campaign first.