The answer here has nuances. In general, yes, you need to have a basic sense of size - you would likely be making awful business decisions if you didn't know whether a project would need 1 developer for a month or 20 developers for a year.
However, it is not so simple as "How many lines of code do you think this would be?", because lines of code is loosely correlated, at best, with effort required and quality. For example, an elegantly refactored code base might cut down code by 10 % and improve performance or ease of future programming, but actually take MORE resources and effort to develop. Additionally, lines of code would be difficult to estimate at the outset of a project.
What you really need to know is an estimate of the level of effort required to get to the minimally viable product, and how many iterations you would need beyond that to really reach your vision for the product.