The
AIP Statistics webpage might help you find some of the answers you're looking for. The information there can show you who's hiring physics graduates, the job outlook, etc.
The other more subjective questions depend on a lot of factors such as your own personal goals, what you enjoy doing, how you learn, etc. A BSc in physics is not for everyone. If your primary goal is professional training then it might not be the right fit for you - you might want to look at engineering instead. Physics is an academic degree and the primary focus of most undergraduate programs is to train students to get into graduate school. That said, lots of physics graduates go on to have wonderful careers even after leaving academia.