While being a plumber is not the most exciting work, it's a very honest (and important) job. However, not everyone is cut out to be one. This video by United Association discusses what a job as a plumber entails, which should help you figure out if this is the right career path for you.
One thing that needs to be understood is that being a plumber is not just fixing leaky sinks. Sure, that's an aspect of being a plumber, but it's one of many different things. Plumbers are necessary to ensure that normal operations in virtually all businesses, households, and organizations are able to continue. Without quality plumbers inspecting and monitoring plumbing systems, these places may run the risk of piping systems degrading or the water becoming unsafe for consumption, either by humans or animals.
Another significant aspect of going into plumbing is that it's not a dead-end job. Most people who have a significant job in plumbing start out doing the basics. Getting a basic understanding of how plumbing systems work is the first stepping stone to being able to work on making and managing plumbing systems yourself. Once you know the basics, there's lots of room to grow with plumbing services.