I think it would be very useful and would be happy to eat it, though AFAIK some vegans are still against it as it still, at least initially, involves the use of dead animals in researching/creating it in the first place.
I honestly think there's probably something a little unhinged about any person who wouldn't prefer it, as the only reason I can think of for feeling such a way would be that the animal suffering (arguably minimal, but still present) is of value to them.
Oh I think there would be a long changeover period and there would almost certainly be various foodie types still eating meat.
People still buy non free range chickens/eggs etc.. most people don't bat an eyelid if the fried chicken they buy from some takeaway is halal etc.. the French are still big on foie gras, the Chinese, Japanese have some live dishes that are pretty messed up.
I'd hope that the early adoption of this stuff would be to replace that sort of cheap chicken, along with burgers, sausages etc.. given that people don't care if that stuff is battery farmed or halal or whatever etc.. then they'll likely pay little attention to whether it is lab grown either, in fact lab grown is probably automatically halal/kosher too so that problem is easily solved.
It would be interesting to see if we start eating insects in future, if bug burgers etc.. become a thing I wouldn't have an issue with that, likewise I'd assume that this lab grown stuff would initially just replace say generic "chicken" and "beef" etc.. but things like prawns, crab, muscles etc.. that have less of a market would perhaps be less of a priority (and perhaps technically more of a challenge too). Then again ethically I think eating say muscles or prawns (or insects if they become a thing) is rather different.
This is where I think some of the resistance will come in, I suspect there will inevitably be a crossover period where this synthetic meat stuff isn't good for much more than say making sausages or fried chicken or using in curries etc... but it isn't going to be the same (initially) as say getting different cuts of beef for use in steaks, or leg meat vs breast meat etc.. in chickens or indeed high quality corn fed chicken etc... However once it has been perfected and you can even get say synthetically produced Kobe steak etc.. I reckon there will be some foodie types who will refuse it..
Even once it is perfected and you can show repeatedly that you can't tell the difference in a blind test of say lab produced vs real meat you'll get some numpty claiming they've got golden tastebuds etc.. similar to audiophiles and hi-fi equipment.
People are taken in by marketing, they want to feel special etc.. I suspect there will still be some expensive restaurants selling real meat (at reassuringly high prices since few farms would exist by then) even if lab grown meat replaces it for the vast majority of us.