Will I still be a part of a project after it is handed over to a team member?

Yes. Once you hand over a project, you become the project's owner.

If you would like to be removed from the project, you can assign the Project Owner role to another member of your project team from the "Project Team" area. They can then remove you from the project.