WordPress add_options_page() function not considering role

Your understanding is incorrect. The third parameter to the add_options_page() function is Capability, not Role.

This is made clear by the function’s prototype:

function add_options_page( $page_title, $menu_title, $capability, $menu_slug, $function = '' )

manage_options is a Capability. Administrator is not.

error code: 523