Why would they have to be breathing? The drug moves from the nasal mucosa to the bloodstream. As long as you get it in their nose it’ll be absorbed.

Now I could see it not working as well if they aren’t breathing since it will likely be distributed over a smaller surface area.