Is using register_activation_hook required?

You don’t have to use the register_activation_hook or register_deactivation_hook hook, they are optional. As their name suggests, they are hooks planned to run a task on plugin’s activation/deactivation, such as updating the status of all users for some purpose.

So, if your plugin doesn’t require such tasks, then simply don’t use them. If you want to register new post types and taxonomies, you can use the init hook instead.