I would not recommend it, You will need to remove your existing Headliner Board out of your car, then with a scrub brush remove all the old foam.
If you attempt this in the car all the old foam backing will fall onto the seats and carpets.
Plus when your spraying the the new adhesive you wont want to get it on your Upholstery either.
If your looking for a temporary solution until you can get it replaced we would recommend only using thumb tacks.
We Recommend Against:
Using a spray adhesive with out replacing your existing material will only bleed through your existing cloth with the absence of the foam backing and make a bigger mess.
Let me know how i can help. Bill