I don't have a lot of experience in this ... but have taught a little at universities here and there over the years.
Obviously, there is a lot of variation among schools -- and the job experience also varies greatly depending on the type of job you have there. At one extreme are the research intensive universities and "tenure track" positions. On the tenure track at such a place, there will be expectations that you do research -- as well as serve on committees, etc. Teaching classes in only one part of the job.
However, even major universities sometimes hire faculty in "non-tenure track" positions. Sometimes, such positions are full time and include benefits: other times, they are part time or adjunct positions that don't. In such positions, you may be hired to simply teach one class or a couple of classes (such as clinical rotations) without being given the other responsibilities of a full time faculty member. So, what kind of positions are available at your local colleges and universities?
There are also 4-year BSN programs that are less research intensive and focus more on teaching and service to the school than research. Usually, the same employment possibilities apply at such schools -- but even on the tenure track, research is stressed less than teaching. Once again, what kind of colleges/universities are you considering? ... and ... What types of positions are you looking at?
I suggest you get some information on the particular schools in question. Do you know anybody who works there? ... or anybody familiar with those schools? Explore their websites. Talk to people. Perhaps some of your collegues at the Community College can give you some information. Do any of your former classmates work in any of those schools. That's where any networking you have done over the years can help you.
Finally ... you can always submit an application and use those first contacts with the search committee as opportunities to ask questions. If you feel that you are not a good fit for that school, you can always withdraw your application early in the process.