Headliner Glue

Weldwood contact cement won't let you down.
You will need to clean off the non drying aerosol glue with some naptha
to get down to a clean dry surface suitable for contact adhesive.
Sadly you just learned the hard way about adhesive in aerosol cans.
It is formulated to never dry so it has a shelf life and can be sprayed from the can.
Great for selling glue.
Bad for your trim projects where heat and gravity arnt working to your advantage.
It remains sticky or liquid indefinitely when it needs to dry into a solid to work.