What a ridiculous statement. People get all sorts of roofs with all sorts of trade offs. Looks is absolutely one of them. Also, any product that gets popular eventually gets highly optimized manufacturing pipelines bringing the cost down.
It doesn't need to compete with normal panels on only one metric. People will accept longer payoff times for aesthetics or durability if the ratio is right. Also, who really cares about Tesla at this point? Other companies are now producing these panels.
Like everything Musk, it died because of his poor business practices and his politics. The only thing he seems to excel at these days is extracting government money.